Oracle9iAS Portal Developer Kit

name_record & value_record

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

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