remove_string_name_like function

Related topics

Contained in package wwnls_api.

Call this function to delete all strings based on a specified pattern of their names. The wild card '%' can be used to represent zero or more characters and '_' can be used to represent any one character.

Note: If p_sub_domain is not specified, then a value of all is assumed. Here, all is the name of a single subdomain. It does not refer to all subdomains.

function remove_string_name_like

(

p_domain in wwnls_strings$.domain%type,

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

p_name in wwnls_strings$.domain%type

)

return number

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_domain

The domain of the message string to be removed.

Example: WWS

Datatype: in wwnls_strings$.domain%type

p_sub_
domain

The subdomain of the message string.

Example: TEXT, NAVBAR

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

p_name

A name for the message string.

Datatype: in wwnls_strings$.name%type

Returns:

This function returns the number of strings deleted.

Exceptions:

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

Example:

wwnls_api.remove_string_name_like

(

p_domain => 'IPORTAL',

p_sub_domain => 'ALL',

p_name => 'WEL%'

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_domain	The domain of the message string to be removed. Example: WWS Datatype: in wwnls_strings$.domain%type
p_sub_ domain	The subdomain of the message string. Example: TEXT, NAVBAR Datatype: in wwnls_strings$.sub_domain%type Default: 'all'
p_name	A name for the message string. Datatype: in wwnls_strings$.name%type
Returns: This function returns the number of strings deleted. Exceptions: If this function fails to execute, an NLS_EXECUTION_EXCEPTION is raised. Example: wwnls_api.remove_string_name_like ( p_domain => 'IPORTAL', p_sub_domain => 'ALL', p_name => 'WEL%' );

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