Team-Fly |
Oracle PL/SQL Programming Guide to Oracle 8 i Features By Steven Feuerstein | |
Table of Contents | |
Oracle8 i expands significantly the use of triggers to administer a database and publish information about events taking place within the database. By employing database triggers on the system events defined in Oracle8 i , and using Oracle Advanced Queuing within those triggers, you can take advantage of the publish/subscribe capabilities of Oracle8 i . The database event publication feature allows applications to subscribe to database events just as they subscribe to messages from other applications. Trigger syntax is extended to support system and other data events on the database level or on a particular schema level. Trigger syntax also supports a CALL to a procedure as the trigger body. You can now enable the publication of (i.e., define a programmatic trigger on) the following actions:
Here are the new trigger features available in Oracle8 i :
|
Team-Fly |
Top |