This content has been marked as final. Show 3 replies
Unfortunately, nested tables are not supported at the moment in queue payloads (even if you state the nested table command). I tried to use the same thing myself.
Have you considered using an XML type to construct and store your data ? I believe those can be passed in the payload.
I got stuck with this and found the following statement useful (from http://docs.oracle.com/cd/B28359_01/server.111/b28420/manage.htm#sthref503)
You cannot construct a message payload using a VARRAY that is not itself contained within an object. You also cannot currently use a NESTED Table even as an embedded object within a message payload. However, you can create an object type that contains one or more VARRAYs, and create a queue table that is founded on this object type