My Oracle Support Banner

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 APRIL 19, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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