| parsing xml [message #461313] |
Thu, 17 June 2010 06:32  |
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  |
 |
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
