get_value function

Related topics

Contained in package wwpro_api_parameters package.

Call this function to return the scalar value of a parameter, given the parameter name and reference path. If more than one value exists for the specified parameter, only the first is returned.

function get_value

(

p_name in varchar2,

p_reference_path in varchar2

)

return varchar2;

Any user can use this function.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_name

The name of the parameter to be returned.

Datatype: in varchar2

p_reference_path

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

Note: The reference_path is passed to wwpro_api_provider.show.

Datatype: in varchar2

Returns:

This function returns the first value of the specified parameter, or null if the parameter is not found or invalid.

Exceptions:

This function raises no exceptions.

Example:

If a URL has these parameters:

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

Then this call:

l_value varchar2;

l_value := wwpro_api_parameters.get_value

(

p_name =>'empno',

p_reference_path =>'a'

);

Returns:

l_value = '30'

 Notes

  • A scalar value is a single number, value, or data item, as opposed to a vector, matrix, or array (which contain multiple values).

  • The reference path identifies a portlet instance on a page and can be used to target parameters to an individual portlet or to groups of portlets on a given page.

Related topics

Back to top

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