retrieve procedure

Related topics

Contained in package wwpro_api_parameters package.

Call this procedure to retrieve a list of all the URL parameters (names and values), unchanged.

procedure retrieve

(

p_names in out owa.vc_arr,

p_values in out owa.vc_arr

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_names

The names of each parameter.

Note: Duplicates are permitted.

Datatype: in out owa.vc_arr

p_values

The corresponding parameter value.

Datatype: in out owa.vc_arr

Exceptions:

This function raises no exceptions.

Example:

If a URL has these parameters:

http://.......?empno=10;&deptno=10;&a.deptno=20;a.deptno=25&a.folderid=30

Then this call:

l_names owa.vc_arr;
l_values vc_arr;

wwpro_api_parameters.retrieve
(
p_names => l_names,
p_values => l_values
);

Returns the following values in l_names and l_values:

l_names: empno, deptno, a.deptno, a.deptno, a.folderid
l_values: 10, 10, 20, 25, 30

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_names	The names of each parameter. Note: Duplicates are permitted. Datatype: in out owa.vc_arr
p_values	The corresponding parameter value. Datatype: in out owa.vc_arr
Exceptions: This function raises no exceptions. Example: If a URL has these parameters: http://.......?empno=10;&deptno=10;&a.deptno=20;a.deptno=25&a.folderid=30 Then this call: l_names owa.vc_arr; l_values vc_arr; wwpro_api_parameters.retrieve ( p_names => l_names, p_values => l_values ); Returns the following values in l_names and l_values: l_names: empno, deptno, a.deptno, a.deptno, a.folderid l_values: 10, 10, 20, 25, 30

Related topics
Provider parameters API packages	PDK PL/SQL API Reference - Home