Oracle9iAS Portal Developer Kit

set_log_interval procedure

Contained in package wwlog_api_admin.

Call this procedure to set the event log purge interval in days.

Note: If the last log switch happened on 01-JAN-2000, and if the set interval = 21, then the first time that a log call is made when 01-JAN-2000 + 21 (22-JAN-2000) is earlier than the current date, the new destination log is purged and the log switch is performed.

procedure set_log_interval

(

p_interval in integer

);

Users must have at least the Any Log - Edit privilege to set a log interval.

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

p_interval

The number of days to be set between event log purges.

Datatype: in integer

Exceptions:

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

Example:

wwlog_api_admin.set_log_interval

(

21

);

Related topics

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