purge_log procedure

Related topics

Contained in package wwlog_api_admin.

Use this procedure to delete all log records from the specified log.

procedure purge_log

(

p_current_log in number

);

This function removes ALL log records from the specified table.
A user must have at least the ANY LOG EDIT privilege to call this procedure.

Version: Oracle Portal 3.0.6.6.5 or later

Parameter:

p_current_log

Indicates which log will be purged.

Notes:

Pass 1 to purge all log records in wwlog_activity_log1$.

Pass 2 to purge all log records in wwlog_activity_log2$.

Datatype: in number

Exceptions:

If a user who attempts to use this procedure has insufficient privileges, a NOT_ENOUGH_PRIVILEGES_EXCEPTION is raised.

Example:

wwlog_api_admin.purge_log

(

p_current_log => 1

);

Version: Oracle Portal 3.0.6.6.5 or later
Parameter:
p_current_log	Indicates which log will be purged. Notes: Pass 1 to purge all log records in wwlog_activity_log1$. Pass 2 to purge all log records in wwlog_activity_log2$. Datatype: in number
Exceptions: If a user who attempts to use this procedure has insufficient privileges, a NOT_ENOUGH_PRIVILEGES_EXCEPTION is raised. Example: wwlog_api_admin.purge_log ( p_current_log => 1 );

Related topics
Event logging API package	PDK PL/SQL API Reference - Home