3 Replies Latest reply on Aug 22, 2012 5:47 PM by Marco Gralike

    read a xml to table


      Someone may indicate a book or tutorial on xml oracle

      I have an xml file and I import to a table, but do not even know how to begin

      Using 9.2.02 version

      Edited by: muttleychess on Aug 22, 2012 9:00 AM
        • 1. Re: read a xml to table
          If you look in the FAQ for this forum {thread:id=410714}, you will notice that the min supported DB version for any sort of XML related functionality is So ... until you upgrade you will have to treat the data as a CLOB/string.

          Or DOMDocument as this thread references {thread:id=2430192}. In other words, act like you are on 8i for dealing with XML.

          Edited by: A_Non on Aug 22, 2012 10:16 AM
          Added DOMDocument reference. Not sure how I forgot that.
          • 2. Re: read a xml to table
            Sorry , my version is
            Oracle9i Enterprise Edition Release - 64bit Production
            PL/SQL Release - Production
            CORE     Production
            TNS for IBM/AIX RISC System/6000: Version - Production
            NLSRTL Version - Production
            • 3. Re: read a xml to table
              Marco Gralike
              The import into table for 9.2/9.1 method/solution is mentioned in the XMLDB FAQ by A_Non