Home » Developer & Programmer » JDeveloper, Java & XML » parsing xml
parsing xml [message #461313] Thu, 17 June 2010 06:32 Go to next message
abc_raj
Messages: 1
Registered: June 2010
Location: manama
Junior Member

hi

i am new to XML . i have stored the xml document as a CLOB Variable in a table.

how to segregate each an every value using SQL/PLSQL, basically i want to store the individual tag value in separate columns

i tried the below sql and got an error inconsistent datatypes.

can someone help ?


SQL> select extractvalue(XMLLINE, '/Document/pacs.008.001.01/GrpHdr/MsgId') from UM_TEST_X;

ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -

Re: parsing xml [message #461316 is a reply to message #461313] Thu, 17 June 2010 06:37 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There are many examples in "JDeveloper, Java & XML" forum.
Without more information on your specific case we cannot help more.

Regards
Michel
Previous Topic: How to pass XML Parameter
Next Topic: Generate XML format
Goto Forum:
  


Current Time: Thu Mar 28 10:27:08 CDT 2024