delete_value procedure

Related topics

Contained in package wwpre_api_value.

Call this procedure to delete the value of a preference, based on its level name.

procedure delete_value

(

p_path in varchar2,

p_name in varchar2,

p_level_type in varchar2,

p_level_name in varchar2

);

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_path

The path for the preference name.

Datatype: in varchar2

p_name

The preference name.

Datatype: in varchar2

p_level_type

A constant value for the level of the value to be deleted.

Datatype: in varchar2

p_level_name

Then user name or group name of the value to be deleted.

Note: If the level is SYSTEM, then the level name must be NULL.

Datatype: in varchar2

Exceptions:

If the path is not found, a PATH_NOT_FOUND_EXCEPTION is raised.

If a duplicate path is found, a DUPLICATE_PATH_EXCEPTION is raised.

If the name is not found, a NAME_NOT_FOUND_EXCEPTION is raised.

If a duplicate preference name exists for the specified path, a DUPLICATE_NAME_EXCEPTION is raised.

If the value has not been deleted, a GENERAL_PREFERENCE_EXCEPTION is raised.

Example:

wwpre_api_value.delete_value

(

p_path => 'ORACLE.TOOLS.PORTAL.STYLE',

p_name => 'BGCOLOR',

p_level_type => wwpre_api_value.USER_LEVEL_TYPE,

p_level_name => wwctx_api.get_user

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_path	The path for the preference name. Datatype: in varchar2
p_name	The preference name. Datatype: in varchar2
p_level_type	A constant value for the level of the value to be deleted. Datatype: in varchar2
p_level_name	Then user name or group name of the value to be deleted. Note: If the level is SYSTEM, then the level name must be NULL. Datatype: in varchar2
Exceptions: If the path is not found, a PATH_NOT_FOUND_EXCEPTION is raised. If a duplicate path is found, a DUPLICATE_PATH_EXCEPTION is raised. If the name is not found, a NAME_NOT_FOUND_EXCEPTION is raised. If a duplicate preference name exists for the specified path, a DUPLICATE_NAME_EXCEPTION is raised. If the value has not been deleted, a GENERAL_PREFERENCE_EXCEPTION is raised. Example: wwpre_api_value.delete_value ( p_path => 'ORACLE.TOOLS.PORTAL.STYLE', p_name => 'BGCOLOR', p_level_type => wwpre_api_value.USER_LEVEL_TYPE, p_level_name => wwctx_api.get_user );

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