Create Queue Table or Queue, or Start Queue Fails with ORA-24000: invalid value should be of the form [SCHEMA.]NAME (Doc ID 2760758.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Attempt to create a queue table using DBMS_AQADM.CREATE_QUEUE_TABLE, or create a queue using DBMS_AQADM.CREATE_QUEUE, or start an existing queue using DBMS_AQADM.START_QUEUE fails with:

ORA-24000: invalid value <schema>.<name> should be of the form [SCHEMA.]NAME

For example:

-- TESTAQ is an example user/schema and HYPHEN-QT is an example name of queue table

-- in 12c

SQL>BEGIN
   DBMS_AQADM.CREATE_QUEUE_TABLE(
      queue_table            => 'TESTAQ.HYPHEN-QT',
      queue_payload_type     => 'SYS.AQ$_JMS_TEXT_MESSAGE');
END;
/ 

BEGIN
*
ERROR at line 1:
ORA-24000: invalid value TESTAQ.HYPHEN-QT, QUEUE_TABLE should be of the form
[SCHEMA.]NAME
ORA-06512: at "SYS.DBMS_AQADM", line 115
ORA-06512: at line 2

-- in 19c

SQL> BEGIN
   DBMS_AQADM.CREATE_QUEUE_TABLE(
      queue_table            => 'TESTAQ.HYPHEN-QT',
      queue_payload_type     => 'SYS.AQ$_JMS_TEXT_MESSAGE');
END;
/
BEGIN
*
ERROR at line 1:
ORA-24000: invalid value TESTAQ.HYPHEN-QT, QUEUE_TABLE should be of the form
[SCHEMA.]NAME
ORA-06512: at "SYS.DBMS_AQADM", line 415
ORA-06512: at "SYS.DBMS_AQADM", line 69
ORA-06512: at "SYS.DBMS_AQADM_INV", line 325
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 312
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 367
ORA-06512: at "SYS.DBMS_AQADM_INV", line 300
ORA-06512: at "SYS.DBMS_AQADM_INV", line 374
ORA-06512: at "SYS.DBMS_AQADM", line 53
ORA-06512: at "SYS.DBMS_AQADM", line 392
ORA-06512: at line 2

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.