Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

AQ: CREATE_QUEUE_TABLE problem

JackKMay 18 2021 — edited May 18 2021

Hi!
I have a type:

create or replace type t_numbers is table of number(22);

CREATE TYPE queue_payload_t AS OBJECT (
 m_type  varchar2(20)
 ,m_ids  t_numbers
 ,m_text  varchar2(300)
);
/

Then I want to create a queue table:

BEGIN
 DBMS_AQADM.CREATE_QUEUE_TABLE (
    queue_table    => 'AQ_queue_table',
    queue_payload_type => 'queue_payload_t'
 );
END;
/

but I am receiving an error:
ORA-22913: trzeba podać nazwę tabeli dla kolumny zagnieżdżonej tabeli lub dla atrybutu
ORA-06512: przy "SYS.DBMS_AQADM", linia 415ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 3491
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 4059
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 3103
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 327
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 135
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 227
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 286
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 3074
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 3801
ORA-06512: przy "SYS.DBMS_AQADM_SYS", linia 3469
ORA-06512: przy "SYS.DBMS_AQADM", linia 406
ORA-06512: przy linia 2
How may I fix this?
This post has been answered by Solomon Yakobson on May 18 2021
Jump to Answer

Comments

Processing

Post Details

Added on May 18 2021
4 comments
183 views