OraFAQ Forum: JDeveloper, Java & XML

Home » Developer & Programmer » JDeveloper, Java & XML » XML Parsing (9i and 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

XML Parsing [message #482951]

Wed, 17 November 2010 01:39

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.

Report message to a moderator

Re: XML Parsing [message #482955 is a reply to message #482951]

Wed, 17 November 2010 02:00

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 26 00:58:42 CST 2025