PL/SQL API jcs_registry.get_value

Summary

• function get_value(key_id in number) return varchar2
• function get_value(pathname in varchar2) return varchar2 ( Note, that registry paths can be different, although you can create the same registry paths if you want. When you search for a path like ''/USER/[user]/...'', it will also check ''/user/[user]/...'' where [user] is the connected Oracle (Cronacle 7) user, not the Cronacle 8 user! )

Get a value.

note

You must have access to the key. If you query for a descendant of ROOT_CURRENT_USER and there is a equivalent entry down ROOT_ALL_USERS then that value will be used if there is no ROOT_CURRENT_USER value or if the ROOT_ALL_USERS value has the override flag set.

Specification

function get_value(key_id in number)
    return varchar2

Parameters

• key_id - the key id for the number overlay
• returns varchar2 -

Specification

function get_value(pathname in varchar2)
    return varchar2

Parameters

• pathname - the key id (path) for the varchar2 overlay
• returns varchar2 -

Examples

An example of how to get a value
         var value varchar2
         begin
         :value := jcs_registry.get_value('/USER/jcsusr/TESTK1');
         end;
         /
         select :value from dual;

An example of how to get a value

plsqlTopic

onsiteTopic