parsing xml [message #461313] |
Thu, 17 June 2010 06:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|