Home » Developer & Programmer » JDeveloper, Java & XML » XML Parsing (9i and 10g)
XML Parsing [message #482951] Wed, 17 November 2010 01:39 Go to next message
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
Michel Cadot
Messages: 58489
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

Previous Topic: To find the number of nodes under a parent node (XML) (merged)
Next Topic: Reading XML
Goto Forum:
  


Current Time: Tue Jul 22 19:21:57 CDT 2014

Total time taken to generate the page: 0.55595 seconds