Oracle9iAS Portal Developer Kit

get_language function

Contained in package wwnls_api.

Call this function to return a language name for a specified language abbreviation or an NLS language name constant.

function get_language

(

p_language in wwnls_strings$.language%type

)

return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_language

A two or three-letter language constant.

Datatype: in varchar2

Returns:

This function returns the full name of the language stored in Oracle Portal NLS tables.

Exceptions:

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

Example:

This example returns 'AMERICAN'.

declare

l_language varchar(2000)

begin

l_language := wwnls_api.get_language

(

p_language => 'us'

);

end;

Related topics

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