|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
Client events [Oracle]
Triggers can be created to be fired when a certain client event happens.
Available client events
A trigger can be created on the following client events in 10g.
For alter table events, the ora_is_alter_column and ora_is_drop_column event attribute functions can be used.
before/after associate statistics
ora_dict_obj_name_list and ora_dict_obj_owner_list are event attribute functions that can be used for this event.
For the special case of a trigger on create table, the ora_is_creating_nested_table event attribute function can be used.
ora_grantee, ora_privileges, ora_with_grant_option are event attribute functions that can be used for this event.
A trigger for this event can also use the ora_client_ip_address function.
A trigger for this event can also use the ora_revokee function.
A trigger for this event can also use the ora_server_error, ora_is_server_error and space_error_info function.
In triggers for client events, the following event attribute functions can be used:
The following attribute functions can be used in all client events except before/after audit, before logoff, after logon and after suspend:
See also system events.