get_values_table function

Related topics

Contained in package wwpre_api_util.

Call this function to get the table of preference value records. This function returns a table of all the records for a given name ID.

function get_values_table
(
p_name_id in number
)
return values_table;

Version: Oracle Portal 3.0.8

Parameters:

p_name_id

The name ID.

Datatype: in number

Returns:

This function returns the preference value table.

Exceptions:

None

Exceptions:

declare

l_name_record wwpre_api_util.name_record;
l_values_table wwpre_api_util.values_table;

begin

l_name_record := wwpre_api_util.get_name
(
p_path => 'ORACLE.TOOLS.PORTAL.STYLE',
p_name => 'BGCOLOR'
);

l_values_table := wwpre_api_util.get_values
(
p_name_id => l_name_record.id
);

end;

Version: Oracle Portal 3.0.8
Parameters:
p_name_id	The name ID. Datatype: in number
Returns: This function returns the preference value table. Exceptions: None Exceptions: declare l_name_record wwpre_api_util.name_record; l_values_table wwpre_api_util.values_table; begin l_name_record := wwpre_api_util.get_name ( p_path => 'ORACLE.TOOLS.PORTAL.STYLE', p_name => 'BGCOLOR' ); l_values_table := wwpre_api_util.get_values ( p_name_id => l_name_record.id ); end;

Related topics
Preference API package	PDK PL/SQL API Reference - Home