Oracle9iAS Portal Developer Kit

add_log_registry function

Contained in package wwlog_api_admin.

Call this function to add a record to the wwlog_registry$ table. The wwlog_registry$ table controls which logging calls are saved to the database.

Each time a call is made to a wwlog_api.log procedure, the new log record's values are compared to the records in the wwlog_registry$ table. If the comparison returns at least one record from the registry table, then a new log record is added to the database activity log.

Note: You can also add a record to the wwlog_registry$ table by clicking Log Registry Administration in the Services portlet (Administer tab in Oracle Portal).

function add_log_registry

(

p_domain in varchar2,

p_subdomain in varchar2 default '%',

p_name in varchar2 default '%',

p_userid in varchar2 default '%',

p_action in varchar2 default '%',

p_http_user_agent in varchar2 default '%',

p_language in varchar2 default '%'

)

return number;

Version: Oracle Portal 3.0.6.6.5 or later

Parameters:

 p_domain

The domain name for the object being logged.

Datatype: in varchar2

p_subdomain

The subdomain name of the object being logged.

Datatype: in varchar2
Default: '%'

p_name

The name of the object being logged.

Datatype: in varchar2
Default: '%'

p_userid

The user ID of user executing the action.

Datatype: in varchar2
Default: '%'

p_action

The name of the action being logged.

Datatype: in varchar2
Default: '%'

p_http_user_agent

The type of the browser being used.

Datatype: in varchar2
Default: '%'

p_language

The language associated with logged event.

Datatype: in varchar2
Default: '%'

Returns:

This function returns the ID number of the logging filter record.

Exceptions:

This function raises no user-defined exceptions.

Example:

p_id := wwlog_api_admin.add_log_registry

(

p_domain => 'Research&Development',

p_subdomain => 'Expenses',

p_name => '%',

p_action => 'view',

p_userid => '%',

p_http_user_agent => '%',

p_language => '%'

);

Related topics

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