Database Events and Oracle Stored Database Procedures
OpenSQL DBEvent statements such as RAISE DBEVENT are not allowed in Oracle stored database procedures. However, Oracle DBMS_ALERT statements such as DBMS_ALERT.RAISE are allowed.
Note: Using OpenSQL DBEvent statements outside of Oracle stored database procedures is more portable than using Oracle DBMS_ALERT statements inside stored database procedures.
To execute a package such as DBMS_ALERT from within an Oracle stored database procedure, a user must be explicitly granted execute permissions on that package by its owner. For the DBMS_ALERT package, the owner is SYSTEM. Permissions implicit in the user's Oracle roles are not available in Oracle stored database procedures.
Last modified date: 02/16/2024