Oracle PL/SQL/System Packages/DBMS AQADM
DBMS_AQADM.CREATE_QUEUE
<source lang="sql">
SQL> SQL> SET ECHO ON SQL> SQL> BEGIN
2 DBMS_AQADM.CREATE_QUEUE ( 3 "EMP_DEPT_CHANGES", 4 "EMP_CHANGES"); 5 END; 6 /
BEGIN
ERROR at line 1: ORA-24006: cannot create QUEUE, sqle.EMP_DEPT_CHANGES already exists ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3131 ORA-06512: at "SYS.DBMS_AQADM", line 119 ORA-06512: at line 2
SQL> SQL> SQL> --
</source>
DBMS_AQADM.CREATE_QUEUE_TABLE
<source lang="sql">
SQL> SQL> SET ECHO ON SQL> SQL> SQL> CREATE OR REPLACE TYPE emp_chg AS OBJECT (
2 emp_id NUMBER, 3 pay_rate NUMBER(9,2), 4 pay_type CHAR(1), 5 leave_dept NUMBER 6 ); 7 /
SQL> SQL> BEGIN
2 DBMS_AQADM.CREATE_QUEUE_TABLE ( 3 "EMP_CHANGES", 4 "EMP_CHG", 5 NULL, 6 "priority,enq_time", 7 TRUE, 8 DBMS_AQADM.NONE, 9 "For pay rate and department changes.", 10 TRUE,0,0, 11 "8.1" 12 ); 13 END; 14 /
SQL> SQL> --
</source>
DBMS_AQADM.START_QUEUE
<source lang="sql">
SQL> SQL> SET ECHO ON SQL> SQL> BEGIN
2 DBMS_AQADM.START_QUEUE("EMP_DEPT_CHANGES"); 3 END; 4 /
PL/SQL procedure successfully completed. SQL> SQL> SQL> --
</source>