XML Parsing [message #482951] |
Wed, 17 November 2010 01:39 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
amit_kiran
Messages: 50 Registered: July 2006 Location: UK
|
Member |
|
|
Hi,
Is there any XML parsing package in Oracle 10g or 9i?
I want to parse XML from a LONG datatype, retrieve value and store it in another database table.
Thanks a lot.
Amit.
|
|
|
Re: XML Parsing [message #482955 is a reply to message #482951] |
Wed, 17 November 2010 02:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68653 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:Is there any XML parsing package in Oracle 10g or 9i?
SQL> select object_name from dba_objects where object_name like '%XML%' and owner='SYS' and object_type='PACKAGE';
OBJECT_NAME
--------------------------------------------------
DBMS_XMLGEN
DBMS_XMLQUERY
DBMS_XMLSAVE
DBMS_XMLSTORE
UTL_XML
XML_SCHEMA_NAME_PRESENT
You will find many examples of their usage in this forum.
Quote:I want to parse XML from a LONG datatype, retrieve value and store it in another database table.
You have to FIRST convert LONG to CLOB.
And NEVER EVER use LONG.
Regards
Michel
[Updated on: Wed, 17 November 2010 02:01] Report message to a moderator
|
|
|