DBMS_AQADM.CREATE_QUEUE : DBMS_AQADM « System Packages « Oracle PL / SQL

1. Oracle PL / SQL
2. System Packages
3. DBMS_AQADM

DBMS_AQADM.CREATE_QUEUE

 
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,
JAVA2S.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> --

 

Related examples in the same category