0 Replies Latest reply on May 23, 2013 8:58 PM by 1010731

    Not able to dequeue XML data into oracle database table


      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)

      Kindly advice.