 Parse XML Blob in PL/SQL [message #203445] |
Wed, 15 November 2006 02:59  |
kyuubi_scarhead
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  |
JRowbottom
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
