Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Object Type with Nested Table as AQ Payload

Status
Not open for further replies.

cardy

Technical User
Sep 5, 2000
33
GB
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top