I am new to oracle queue. I have been trying to send XML data using Queue to Queue propagation ( from one queue to other queue in another oracle database). I am able to enqueue data. And as per propagation defined, data is available in queue table in another destination database (both are oracle same version database). I am trying to achieve this using oracle PL/SQL. These Queues are holding XMLtype data.
I want to put this queue data into oracle database tables while dequeing. I am trying to do it manually by extracting (XML extract syntax) data from each node and saving it respective tables which is very painful.
But i dont know what other usefull method to get XML data and store it into oracle database table in regular format (not in XML format)