Oracle9iAS Portal Developer Kit

remove_string function (id)

Contained in package wwnls_api.

Call this function to remove either a single translation of a string, or all translations of a string.

function remove_string

(

p_id in wwnls_strings$.id%type,

p_remove_all in boolean default false

)

return number;

If a base string is deleted, all translations for the specified string are deleted.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_id

A message string ID.

Datatype: in wwnls_strings$.id%type

p_remove_all

Indicates if all translations for a specified string should be removed:

  • TRUE removes all strings of the specified language.

  • FALSE removes only the specified string.

Datatype: in boolean
Default: false

Returns:

This function returns the number of rows deleted.

Exceptions:

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

Example:

This example deletes all translated strings.

l_number := wwnls_api.remove_string

(

p_id => l_layout.title_id,

p_remove_all => true

);

Related topics

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