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/DataSh eet/Parame ters/Range Spec/Measu red
') from dual;
though it doesnt work..but what can i do to run the above?
can i do soemthing liek this
select extractValue(select XML_DATA
from datav6
where id=5713,'/FinalData/DataSh
') from dual;
though it doesnt work..but what can i do to run the above?
ASKER
i tried aboeve and gave this errr
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected - got -
ASKER
ok i had to do select extractvalue(xmltype(clobd ata..)
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.
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.
ASKER
what is the best way to parse huge xml then.
xmldom or using substr or what
xmldom or using substr or what
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
select extractValue(XML_DATA ,'/FinalData/DataSheet/Par
from from datav6
where id=5713
/