get_translations (id)

Related topics

Contained in package wwnls_api.

Call this function to return all the translations of a string, given a string ID.

function get_translations

(

p_id in wwnls_strings$.id%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: Oracle9iAS Portal 9.0.2 or later

Parameters:

p_id

The message string ID.

Datatype: in wwnls_strings$.id%type

Returns:

This function returns a string_array containing all the translations of a string, given message string ID.

Exceptions:

If this function fails to execute, NLS_EXECUTION_EXCEPTION is raised.

Example:

declare

l_string_id number;
l_translations wwnls_api.string_array;

begin

l_string_id := wwnls_api.get_id(

p_domain => 'MAP_PROVIDER',
p_sub_domain => 'MAP_PORTLET',
p_name => 'PORTLET_TITLE',
p_language => wwnls_api.AMERICAN);

l_translations := wwnls_api.get_translations(

p_id => l_string_id);

end;

Version: Oracle9iAS Portal 9.0.2 or later
Parameters:
p_id	The message string ID. Datatype: in wwnls_strings$.id%type
Returns: This function returns a string_array containing all the translations of a string, given message string ID. Exceptions: If this function fails to execute, NLS_EXECUTION_EXCEPTION is raised. Example: declare l_string_id number; l_translations wwnls_api.string_array; begin l_string_id := wwnls_api.get_id( p_domain => 'MAP_PROVIDER', p_sub_domain => 'MAP_PORTLET', p_name => 'PORTLET_TITLE', p_language => wwnls_api.AMERICAN); l_translations := wwnls_api.get_translations( p_id => l_string_id); end;

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