Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> XML to relational table question

XML to relational table question

From: g3000 <carlton_gregory_at_yahoo.com>
Date: 9 Jun 2005 08:08:32 -0700
Message-ID: <1118329712.855751.73200@o13g2000cwo.googlegroups.com>


This is what I think I know:

          If you have an XML doc that you would like to load into
          an relational table you must first transform it with
          XSLT into Oracles canonical format.
          After it is in Oracles canonical format you can then
          use an XDK api to load it ( DBMS_XMLSAVE ).
          You could use XML DB but you would have to use XSD and
          it would load in tables created from the XSD NOT YOUR
          relational table.


My question is does DBMS_XMLSAVE parse the document using the DOM parser?

If so is there a way to use SAX parser instead? From reading it seems as if DOM will load the whole doc in memory to parse it. Im on 9.2.0.6.0.

Thank you for your time Received on Thu Jun 09 2005 - 10:08:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US