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.

before/after alter

For alter user events, the ora_des_encrypted_password event attribute functions can be used.
For alter table events, the ora_is_alter_column and ora_is_drop_column event attribute functions can be used.

before/after drop

before/after analyze

before/after associate statistics

before/after audit

before/after nouadit

before/after comment

before/after create

For the special case of a trigger on create table, the ora_is_creating_nested_table event attribute function can be used.

before/after ddl

before/after grant

before logoff

A trigger for this event can also use the ora_client_ip_address function.

after logoff

before/after rename

before/after revoke

A trigger for this event can also use the ora_revokee function.

after suspend

A trigger for this event can also use the ora_server_error, ora_is_server_error and space_error_info function.

before/after truncate

attribute functions

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:

Links

See also system events.