0 Replies Latest reply: Dec 4, 2012 4:20 PM by user705850 RSS

    Oracle DB to XML mapping

    user705850
      An oracle webservice is written to accept single record data. I have to map a data table to xml using odi and pass this xml as input to the webservice.
      I created the xml/xsd file based on the webservice (wsdl). When I do reverse engineer, all the columns(basically elements) are created as table in the schema.
      Target datastore will be xml and source will be the oracle table.
      Since the xml is creating a table for each column how do I achieve this?