1 Reply Latest reply on Feb 21, 2012 3:50 PM by odie_63

    Input/Output as XML for Oracle Procedure


      Please guide me or help me below

      I have to write a procedure input as a XML file and do some process inside of procedure like inserts/updates oracle table or retrieve data from xml file and have to send XML file as output to that procedure.

      Thanks in advance

        • 1. Re: Input/Output as XML for Oracle Procedure

          That's a broad topic.

          I suggest you first search in the forums for terms like "XML to Table", "Store XML file in Oracle", etc.
          You'll find a lot of examples.

          If you have issues with a specific case, please post these additional details :

          - database version (SELECT * FROM v$version)
          - sample input XML
          - tables structures
          - requirement (e.g. which XML element goes to which column...)