Oracle9iAS Portal Developer Kit

NLS string records and table structure

In the wwnls_api API package, translated text is stored in string records in the NLS tables.

Version: Oracle Portal 3.0.6.6.5 or later

String records and descriptions

subtype string_record is wwnls_strings$%rowtype;

A subtype of a row from the NLS table.

type string_array is table of string_record index by binary_integer;

A list of records from the NLS table.

type string_text_array is table of wwnls_strings$.text%type
index by binary_integer;

 

NLS table structure

subscriber_id

number default SYS_CONTEXT('WEBDB_VPD_CTX','SUBSCRIBER_ID') not null

id

integer not null

domain

varchar2 (30) not null

sub_domain

varchar2 (32) not null

name

varchar2 (64) not null

language

varchar2 (7) not null

text

long

text_start

varchar2 (256)

base_string_id

integer default null

text_string

varchar2(4000) default null

Schema languages array

type nls_scla_array is table of
wwnls_sys_language$.databaseabbreviation%type
index by binary_integer;

 

 

Related topics

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