Oracle9iAS Portal Developer Kit

retrieve procedure

Contained in package wwpro_api_parameters package.

Call this API to retrieve a name and a value for all parameters from every portlet instance that belongs to a provider. The names and values are returned, unchanged, into a table.

Note: If a parameter has more than one value, only the first is returned.

procedure retrieve

(

p_names in out owa.vc_arr,

p_values in out owa.vc_arr

);

Any user can use this procedure.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_names

Returns the names of the parameters, unchanged, in the specified table.

Datatype: in out owa.vc_arr

p_values

Returns the values of the parameters into the specified table.

Datatype: in out owa.vc_arr

Exceptions:

This procedure raises no exceptions.

Example :

If a URL has these parameters:

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

Then this call:

wwpro_api_parameters.retrieve

(

 l_names,
 l_values

);

Sets these names and values:

'empno', 'deptno', 'a.deptno', 'a.deptno', 'a.folderid' in l_names

and '10', '10', '20', '25', '30' in l_values.

Note

A portlet instance is the display of a portlet on a single page. The same portlet may be displayed multiple times on the same page. Each time a portlet is added to a page, Oracle Portal generates a unique portlet instance ID that is the instance's reference path.

Related topics

The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio