Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> XML to relational table question
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