UTL32K.SQL FAILING WITH ORA-24005 ON AQ QUEUE TABLE (Doc ID 2092248.1)

Last updated on AUGUST 29, 2016

Applies to:

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

Symptoms

NLS_CHARACTERSET       AL32UTF8  

ALTER SESSION SET NLS_LENGTH_SEMANTICS=CHAR;

    BEGIN
        SYS.DBMS_AQADM.CREATE_QUEUE_TABLE
     ( QUEUE_TABLE           =>  'STRMADMIN9.STREAMS_QUEUE_TABLEC'
      ,QUEUE_PAYLOAD_TYPE    =>  'SYS.ANYDATA'
      ,COMPATIBLE            =>  '10.0.0'
      ,SORT_LIST             =>  'COMMIT_TIME'
      ,MULTIPLE_CONSUMERS    =>  TRUE
      ,MESSAGE_GROUPING      =>  1        
      ,SECURE                =>  TRUE
       );
     End;
     /

SQL> @?/rdbms/admin/utl32k.sql

...

DECLARE
*
ERROR at line 1:
ORA-24005: Inappropriate utilities used to perform DDL on AQ table
STRMADMIN9.STREAMS_QUEUE_TABLEC
ORA-06512: at line 121

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms