Home » Developer & Programmer » JDeveloper, Java & XML » Parse XML Blob in PL/SQL
icon5.gif  Parse XML Blob in PL/SQL [message #203445] Wed, 15 November 2006 02:59 Go to next message
Messages: 1
Registered: November 2006
Junior Member
I have an xml file in a blob file.
is it possible for me to parse the xml while in PL/SQL.

so far i was only able to parse an xmlDom.DOMDocument.
the missing link is converting blob to xmlDom.DOMDocument.

thanks in advance for your help

[Updated on: Wed, 15 November 2006 03:00]

Report message to a moderator

Re: Parse XML Blob in PL/SQL [message #203548 is a reply to message #203445] Wed, 15 November 2006 08:46 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you can get the XML into a CLOB instead of a BLOB (it's text data, not binary data, after all), then you can convert it into an XMLTYPE (Oracles internal XML data structure).
Then there are a whole host of functions that you can use, including full Xpath support.
Previous Topic: Ora10g - ORA-31185: DOM Nodes do not belong ...
Next Topic: Temporary Tablespace
Goto Forum:

Current Time: Sun Jul 23 06:05:38 CDT 2017

Total time taken to generate the page: 0.07444 seconds