I'm trying to create an Advanced Queue that has a payload type of an object type which has some attributes which are nested tables i.e.
CREATE TYPE TYP_TAB_VARCHAR60 IS TABLE OF VARCHAR2(60)
/
CREATE TYPE TYP_AQ_PAYLOAD AS OBJECT (
ATTR1 TYP_TAB_VARCHAR60 , ...)
/
EXEC DBMS_AQADM.CREATE_QUEUE_TABLE (
QUEUE_TABLE => 'MY_QUEUE_TABLE' ,
QUEUE_PAYLOAD_TYPE => 'TYP_AQ_PAYLOAD' , .... )
But I get the following error :
ORA-22913: must specify table name for nested table column or attribute
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2012
ORA-06512: at "SYS.DBMS_AQADM", line 55
Anybody know the correct syntax for doing this ?
TIA
Cardy
CREATE TYPE TYP_TAB_VARCHAR60 IS TABLE OF VARCHAR2(60)
/
CREATE TYPE TYP_AQ_PAYLOAD AS OBJECT (
ATTR1 TYP_TAB_VARCHAR60 , ...)
/
EXEC DBMS_AQADM.CREATE_QUEUE_TABLE (
QUEUE_TABLE => 'MY_QUEUE_TABLE' ,
QUEUE_PAYLOAD_TYPE => 'TYP_AQ_PAYLOAD' , .... )
But I get the following error :
ORA-22913: must specify table name for nested table column or attribute
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2012
ORA-06512: at "SYS.DBMS_AQADM", line 55
Anybody know the correct syntax for doing this ?
TIA
Cardy