| 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 );

Related topics
Event logging 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