get_translations (domain, subdomain, name)

Related topics

Contained in package wwnls_api.

Call this function to return all the translations of a string based on domain, subdomain and name.

function get_translations

(

p_domain in wwnls_strings$.domain%type,

p_sub_domain in wwnls_strings$.sub_domain%type default 'all',

p_name in wwnls_strings$.name%type,

p0 in varchar2 default null,

p1 in varchar2 default null,

p2 in varchar2 default null,

p3 in varchar2 default null,

p4 in varchar2 default null,

p5 in varchar2 default null,

p6 in varchar2 default null,

p7 in varchar2 default null,

p8 in varchar2 default null,

p9 in varchar2 default null

)
return string_array;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_domain

The domain for the message string.

Example: WWS

Datatype: in wwnls_strings$.domain%type

p_sub_domain

The subdomain for the message string.

Note: The default 'all' refers to the name of a specific sub-domain. It does not refer to all subdomains.

Example: TEXT, NAVBAR

Datatype: in wwnls_strings$.sub_domain%type
Default: 'all'

p_name

A unique name for a message string.

Datatype: in wwnls_strings$.name%type

(p0, p1, ... p9)

Values used for parameter substitution.

Notes:

These are optional run-time values that may be inserted into the message string.
The message string must contain the markup characters %0, %1, through %9 in order to pass in the appropriate parameter value.

Only the specified non-null values p0 through p9 are used for substitution. Extra values are ignored.

Only non-null values are used for substitution.

Datatype: in varchar2
Default: null

Returns:

This function returns a string_array containing all the translations of a string, given the Domain, Sub-Domain and Name.

Exceptions:

If this function fails to execute, an NLS_EXECUTION_EXCEPTION is raised.

Example:

declare

l_translations wwnls_api.string_array;

begin

l_translations := wwnls_api.get_translations(

p_domain => 'MAP_PROVIDER',
p_sub_domain => 'MAP_PORTLET',
p_name => 'PORTLET_TITLE');

end;

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_domain	The domain for the message string. Example: WWS Datatype: in wwnls_strings$.domain%type
p_sub_domain	The subdomain for the message string. Note: The default 'all' refers to the name of a specific sub-domain. It does not refer to all subdomains. Example: TEXT, NAVBAR Datatype: in wwnls_strings$.sub_domain%type Default: 'all'
p_name	A unique name for a message string. Datatype: in wwnls_strings$.name%type
(p0, p1, ... p9)	Values used for parameter substitution. Notes: These are optional run-time values that may be inserted into the message string. The message string must contain the markup characters %0, %1, through %9 in order to pass in the appropriate parameter value. Only the specified non-null values p0 through p9 are used for substitution. Extra values are ignored. Only non-null values are used for substitution. Datatype: in varchar2 Default: null
Returns: This function returns a string_array containing all the translations of a string, given the Domain, Sub-Domain and Name. Exceptions: If this function fails to execute, an NLS_EXECUTION_EXCEPTION is raised. Example: declare l_translations wwnls_api.string_array; begin l_translations := wwnls_api.get_translations( p_domain => 'MAP_PROVIDER', p_sub_domain => 'MAP_PORTLET', p_name => 'PORTLET_TITLE'); end;

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