Oracle Built−in Packages- P40: Ah, for the good old days of Version of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms , and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Alert names are limited to 30 bytes and are case-insensitive. Alert names beginning with ORA are reserved for use by Oracle Corporation. Example In this example the session will be registered to be notified of the EMP_INSERT alert which is raised whenever INSERTs are performed on the EMP table BEGIN EMP_INSERT END The procedure The REMOVE procedure unregisters a session s interest in receiving notification of a specific alert. It has the following header PROCEDURE name IN VARCHAR2 where name is the name of the alert to unregister from notification. The REMOVE procedure does not raise any package exceptions nor does it assert a purity level with the RESTRICT_REFERENCES pragma. Example The following example unregisters for the EMP_INSERT alert BEGIN EMP_INSERT END The procedure The REMOVEALL procedure unregisters the session from receiving notification of any and all alerts that have been previously registered. Here s the header PROCEDURE The REMOVEALL procedure does not raise package exceptions nor does it assert a purity level with the RESTRICT_REFERENCES pragma. Example This example stops all alert notifications to the session SQL execute The procedure The SET_DEFAULTS procedure is used to set session configurable settings used by the DBMS_ALERT package. Currently the polling loop interval sleep time is the only session setting that can be modified using The DBMS_ALERT Interface 186 Appendix A What s on the Companion Disk this procedure. The header for this procedure is PROCEDURE sensitivity IN NUMBER where sensitivity is the polling interval sleep time in seconds. The SET_DEFAULTS procedure does not raise any package exceptions. Example The following example sets the .
