Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What Are the Options for Storing XML in AQ Message Payloads?

April 26, 2017AQ message Options payloads storing XML

0

Posted

What Are the Options for Storing XML in AQ Message Payloads?

1 Answer

0

Posted

When storing XML in AQ message payloads, is there any other way of natively doing this other than having an ADT as the payload with sys.xmltype as part of the ADT? For example, create or replace type object xml_data_typ AS object (xml_data sys.XMLType); My understanding is that you can ONLY have either a RAW or ADT as message payloads. Answer: In Oracle9.0.1, this is the only way to store XMLTypes in queues. In Oracle9i Release 2 (9.2), you can create queues with payload and attributes as XMLType.