2.2 Event Parameters

When an event occurs, information is stored in parameters that are bundled into an object type called WMSYS.WM$EVENT_TYPE and enqueued into the event queue. A subscriber can dequeue the event object on receiving notification.

The following table describes the Workspace Manager event parameters.

Table 2-2 Workspace Manager Event Parameters

Event Parameter	Data Type	Description
event_name	VARCHAR2(128)	Name indicating the type of event.
workspace_name	VARCHAR2(128)	Workspace that caused the event to occur.
parent_workspace_name	VARCHAR2(128)	Parent workspace of the workspace that caused the event to occur.
user_name	VARCHAR2(128)	User that caused the event to occur.
table_name	VARCHAR2(128)	Version-enabled table on which the event occurred. If this parameter does not apply to an event, it is null.
aux_params	WMSYS.WM$NV_PAIR_NT_TYPE (which is table of WMSYS.WM$NV_PAIR_TYPE)	A nested table of (name,value) pairs that can contain additional information about the event. For TABLE_xxx events, it has one row containing the WHERE clause string used for the operation. For WORKSPACE_VERSION events, it has one row containing the savepoint name associated with the newly created version.