samir25
asked on
hot to parse xml using xpath in pl/sql
hi
so far i had been using dbms_lob.instr/substr...to extract node value from the xml stored as clob in my oracle.
start_position := dbms_lob.instr(r1.xml_data ,'<Excepti on>',1,1) + 11;
end_position := dbms_lob.instr(r1.xml_data , '</Exception>', start_position, 1);
xmldata := dbms_lob.substr(r1.xml_dat a, end_position - start_position, start_position);
now i want to use xpath; because i have a specific case which can be resolved using xpath. i ve this xpath which returns 4 lines to me in the xml file(using its xpath feature)
//SubSheet/DeatiledParamet ers/*/Pass [text()='f alse']/..
can someone help me share how i can use this xpath in oracle pl/sql?
thanks a lot
so far i had been using dbms_lob.instr/substr...to
start_position := dbms_lob.instr(r1.xml_data
end_position := dbms_lob.instr(r1.xml_data
xmldata := dbms_lob.substr(r1.xml_dat
now i want to use xpath; because i have a specific case which can be resolved using xpath. i ve this xpath which returns 4 lines to me in the xml file(using its xpath feature)
//SubSheet/DeatiledParamet
can someone help me share how i can use this xpath in oracle pl/sql?
thanks a lot
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I've deleted the other one as you requested.
Since you've accepted an answer I assume you no longer need assistance with this question.
If you still need assistance please provide the data I requested above and I'll unaccept the answer and continue helping you.
The data I requested above::
"If you can provide some sample data and expected results I'll provide a working example."
Since you've accepted an answer I assume you no longer need assistance with this question.
If you still need assistance please provide the data I requested above and I'll unaccept the answer and continue helping you.
The data I requested above::
"If you can provide some sample data and expected results I'll provide a working example."
ASKER
yes i resolved this tough i am stuck at a dif place for which i will float sep ques
ASKER
here is what want to do
//SubSheet/DeatiledParamet
can you help on this?