An example about receiving Oracle AQ asynchronous notifications using PL/SQL callback functions
$ sqlplus sys/password@XE as sysdba @run_example.sql
Note: tested with Oracle Database Express Edition 11g Release 2
See: https://fcosfc.wordpress.com/2014/12/17/oracle-aq-working-with-plsql-asynchronous-notifications/