In an OTN document, it says that an Oracle database can enqueue and dequeue XML messages and process them. How does it do this?
Do I have to use XML SQL Utility (XSU) in order to insert an XML file into a table before processing it, or can I enqueue an XML file directly, parse it, and dispatch its messages through the AQ process? Must I use XML SQL Utility every time I want to INSERT or UPDATE XML data into Oracle9i Database? Answer: AQ supports enqueing and dequeing objects. These objects can have an attribute of type XMLType containing an XML Document, as well as other interested “factored out” metadata attributes that might make sense to send along with the message. Refer to the latest AQ document, Oracle9i Application Developer’s Guide – Advanced Queuing to get specific details and see more examples.
