Oracle WebDB Online Help

set_string procedure (id, text)

Contained in package wwnls_api.

Call this procedure to modify a translation for an existing string.

procedure set_string

(

p_id in wwnls_strings$.id%type,

p_text in wwnls_strings$.text%type,

p_language in wwnls_strings$.language%type default null

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_id

A message string ID.

Datatype: in wwnls_strings$.id%type

p_text

The translated message string text to be modified.

Datatype: in wwnls_strings$.text%type

p_language

The NLS language name constant of the language for which the translation is provided

Example: wwnls_api.JAPANESE

Datatype: in wwnls_strings$.language%type

Exception:

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

Example:

if sql%rowcount != 0 then

l_long := self.title;

wwnls_api.set_string

(

p_id => self.title_id,

p_text => l_long

);

l_long := self.description;

wwnls_api.set_string

(

p_id => self.description_id,

p_text => l_long

);

else

...

Related topics

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