| NLS string records and table structure

Related topics
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
NLS 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