get_values function (multiple parameter names)

Related topics

Contained in package wwpro_api_parameters package.

Call this overloaded API to return all the values associated with a list of parameter names.

Note: To return values associated with a single parameter name, call get_values function (single parameter name).

function get_values

(

p_names in owa.vc_arr,

p_reference_path in varchar2

)

return owa.vc_arr;

Any user can use this function.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_names

The names of the portlet parameters.

Datatype: in owa.vc_arr

p_reference_path

A unique identifier for a portlet instance on the current page.

Datatype: in varchar2

Returns:

Returns a list of parameter values, or an empty list if no matches are found.

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

and if:

l_names contains 'deptno' and 'folderid'

Then this call:

l_values owa.vc_arr;

l_names owa.vc_arr;

l_values := wwpro_api_parameters.get_values

(

p_names =>l_names,

p_reference_path =>'a'

);

Returns:

20, 25, and 30 for l_values.

Notes

  • An overloaded API is one that has more than one function or procedure of the same name, but with differing numbers and/or types of parameters.

  • 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

Back to top

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