Posted by: eserhan on: February 19, 2009
there are not so many stuff about advanced queues for beginner level. this example may help you to figure out.. — to create queue, some grants are given to our user GRANT “AQ_ADMINISTRATOR_ROLE” TO YTS; GRANT “AQ_USER_ROLE” TO YTS; GRANT EXECUTE ON SYS.DBMS_AQ TO YTS; — queue table is created BEGIN SYS.DBMS_AQADM.CREATE_QUEUE_TABLE ( QUEUE_TABLE => [...]
