| name_record & value_record

Related topics
The wwpre_api_util API package contains the record structures: name_record value_record type name_record is record ( id number, path_id number, name varchar2(255), description long, description_id number, type_name varchar2(200) ); type names_table is table of name_record index by binary_integer; type value_record is record ( name_id number, level_type varchar2(4), level_id number, varchar2_value varchar2(4000), number_value number, date_value date ); type values_table is table of value_record index by binary_integer;
Version: Oracle Portal 3.0.8
Name_record field names | Description
id | The ID of the preference name.
path_id | The ID of the path associated with the preference name.
name | The preference name.
description | A description for the preference name.
description_id | The NLS string ID for the description.
type_name | The name of the type associated with this preference.
Value_record field names | Description
name_id | The preference name ID associated with the value record.
level_type | The type of Level associated with the value. Valid values are: USER_LEVEL_TYPE, GROUP_LEVEL_TYPE, SYSTEM_LEVEL_TYPE
level_id | The User Name or Group Name if the level type is USER_LEVEL_TYPE or GROUP_LEVEL_TYPE respectively. This field is not used when the level type is SYSTEM_LEVEL_TYPE.
varchar2_value | If the value is stored as varchar2, this field holds that value.
number_value | If the value is stored as a number, this field holds that value.
date_value | If the value is stored as a date, this field holds that value.

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

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