3 Replies Latest reply: Aug 22, 2012 12:47 PM by Marco Gralike RSS

    read a xml to table

    muttleychess
      Hi

      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
      Tia

      Edited by: muttleychess on Aug 22, 2012 9:00 AM
        • 1. Re: read a xml to table
          Jason_(A_Non)
          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 9.2.0.3. 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
            muttleychess
            Sorry , my version is
            Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
            PL/SQL Release 9.2.0.8.0 - Production
            CORE     9.2.0.8.0     Production
            TNS for IBM/AIX RISC System/6000: Version 9.2.0.8.0 - Production
            NLSRTL Version 9.2.0.8.0 - 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