OracleAS Portal PL/SQL API Reference

Event Log Record

Each event log record may contain the following fields:

Log record field names and definitions

id

A unique identifier for each logged event.

Notes:

  • Providers can use this property to end a previously started event.
  • The ID is applied to logging events by the API implementation.

domain

The domain name.

Notes:

  • A domain exists for each logical service provided by Oracle Portal, for example, "wwv" and "wwf".
  • Providers are expected to define new domains for their major services.
  • Domain is a non-translatable string value.

sub_domain

The subdomain name.

Notes:

  • A subdomain is a defined group of objects, such as pages, within a domain.
  • To facilitate modularization of logged information, each domain may contain any number of subdomains.
  • Subdomain is a non-translatable string value.

name

The object name.

  • Within each domain and subdomain, events are logged against named objects.
  • A name can be, but is not required to be, a non-translatable string value.

userid

The user ID for the user that was logged into the system when the logging event was started.

Note: The user ID is applied to logging events by the API implementation.

session_id

The ID of the session that the user was in at the time the logging event was started.

Note: The session ID is applied to logging events by the API implementation.

action

The name of the action being performed upon the object.

Notes:

  • The caller of the API should provide a value for this string.
  • An action can be, but is not required to be, a non-translatable string value.

url

The URL for the logged object.

Note: This is an optional URL string that can be used to get back to the object that was logged.

information

A string provided by the caller of the API.

Note: Information can be any string value that the caller wants to capture and include in the logging event.

start_time

The time that the logging event was started.

Notes:

  • The start_time is the current time in the time zone of the machine hosting the logging service.
  • This value is calculated and recorded only by Oracle Portal APIs. Providers cannot record a start time to the log.

dbms_start_time

The value returned by DBMS_UTILITY.GET_TIME when the logging event was started.

Notes:

  • This information is applied to logging events by the API implementation.
  • This value is calculated and recorded only by Oracle Portal APIs. Providers cannot record a start time to the log.

elapsed_time

The time taken to process the event, recorded in seconds.

Note: In some cases, the caller of the API supplies this information, in others the API automatically determines the correct value.

row_count

Specifies the number of rows that were operated upon for the logged action.

Notes:

  • Some common logging operations such as updating, deleting, inserting or reporting operate on a number of rows. In these cases, row_count records this information.
  • If row_count is not specified, it defaults to zero (0).

http_user_agent

The name of the Web browser being used, if known.

Notes:

  • If the logged service was invoked from a browser, this information is applied to the logging event.
  • The API determines the browser name, as it is not provided by the user.

http_remote_
address

The remote address (host name/IP address) of the Web browser being used, if known.

Notes:

  • If the logged service was invoked from a browser, this information is applied to the logging event.
  • The API determines the browser name, as it is not provided by the user.

language

The browser abbreviation of the NLS setting in effect at the time of the log request.

key_1

A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional.

key_2

A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional.

key_3

A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional.

key_4

A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional.

key_5

A column intended to hold data that correlates this log record to any specified data related to the logged event. Use of this column is optional.



OracleAS Portal PL/SQL API Reference

Generated by PL/Doc