This content has been marked as final. Show 3 replies
as you wrote you already have a code snippet with DBMS_AQ.DEQUEUE of an exception queue.
Wrap this DEQUEUE in an infinite loop (LOOP ... END LOOP). In order to have this procedure as an autonomous session
you can start it as a database job:
DECLARE v_jobno NUMBER(6); BEGIN DBMS_JOB.SUBMIT( v_jobno, 'BEGIN <your module>; END;', SYSDATE, NULL ); COMMIT; END; /