get_values function (single parameter name)

Related topics

Contained in package wwpro_api_parameters package.

Call this overloaded API to return all the values associated with a single parameter name.

Note: To return values associated with a list of parameter names, call get_values function (multiple parameter names).

function get_values

(

p_name in varchar2,

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_name

The name of the portlet parameter.

Datatype: in varchar2

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

Then this call:

l_values owa.vc_arr;

l_values := wwpro_api_parameters.get_values
(

p_name =>'depno',
p_reference_path =>'a'

);

Returns:

20 and 25 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