DBA Data[Home] [Help]

FUNCTION: SYS.GET_REALM_PARAMETERS

Source


1 function get_realm_parameters(realm in varchar2) return xs$realm_parameter_table
2 as
3   cnt         pls_integer;
4   param       varchar2(4000);
5   pattern     varchar2(129);
6   rule_params xs$realm_parameter_table := xs$realm_parameter_table();
7 begin
8   pattern := '&[[:alpha:]][[:alnum:]$#_]*';
9   -- Get the list of parameters from the membership rule.
10   cnt := 1;
11   LOOP
12     -- Find one parameter.
13     param := regexp_substr(realm, pattern, 1, cnt, 'i');
14 
15     EXIT WHEN (param IS NULL);
16 
17     rule_params.extend(1);
18     rule_params(cnt) := substr(param, 2);             -- Delete the symbol "&'.
19 
20     cnt := cnt + 1;
21   END LOOP;
22   return rule_params;
23 end;