Link to home
Start Free TrialLog in
Avatar of samir25
samir25

asked on

how to use extractvalue here

hi
can i do soemthing liek this
select extractValue(select XML_DATA
from datav6
where id=5713,'/FinalData/DataSheet/Parameters/RangeSpec/Measured
') from dual;

though it doesnt work..but what can i do to run the above?
Avatar of Sujith
Sujith
Flag of United Kingdom of Great Britain and Northern Ireland image

Why not

select extractValue(XML_DATA ,'/FinalData/DataSheet/Parameters/RangeSpec/Measured')
from from datav6
where id=5713
/
Avatar of samir25
samir25

ASKER

i tried aboeve and gave this errr
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -
Avatar of samir25

ASKER

ok i had to do select extractvalue(xmltype(clobdata..)

and i get this error
ORA-31167: XML nodes over 64K in size cannot be inserted

and i know htis is a oracle issue.nodes >64k cannot be considered.
Avatar of samir25

ASKER

what is the best way to parse huge xml then.
xmldom or using substr or what
ASKER CERTIFIED SOLUTION
Avatar of Sujith
Sujith
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of samir25

ASKER

i m using oracle. and i have done parsing using substr... i was thinkign i can identify another sophisticated approach
i wanted to use xmldom but went thru this artilcel
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:17309127931717
which says should not use xml dom for huge xml..is my understanding correct