| delete_value_by_id procedure

Related topics
Contained in package wwpre_api_value. Call this procedure to delete the value of a preference based on its level ID. procedure delete_value_by_id ( p_path in varchar2, p_name in varchar2, p_level_type in varchar2, p_level_id 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. Note: Use these constants to specify level_type. wwwpre_api_value.SYSTEM_LEVEL_TYPE wwwpre_api_value.GROUP_LEVEL_TYPE wwwpre_api_value.USER_LEVEL_TYPE Datatype: in varchar2
p_level_id | The user ID or group ID for the value to be deleted. Notes: For system level_type, level_id is wwpre_api_value.SYSTEM_LEVEL_ID. For group level_type, level_id is GROUP ID. For user level_type, level_id is USER ID. 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_by_id ( p_path => 'ORACLE.TOOLS.PORTAL.STYLE', p_name => 'BGCOLOR', p_level_type => wwpre_api_value.USER_LEVEL_TYPE, p_level_id => wwctx_api.get_user_id );

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

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