Overview | Package | Object Type | Deprecated | Index | Help
| Oracle9iAS Portal PL/SQL API Reference
| FRAMES NO FRAMES

## 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.

Overview | Package | Object Type | Deprecated | Index | Help
| Oracle9iAS Portal PL/SQL API Reference
| FRAMES NO FRAMES

Generated by PL/Doc