hot to parse xml using xpath in pl/sql
Posted on 2007-08-01
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,'<Exception>',1,1) + 11;
end_position := dbms_lob.instr(r1.xml_data, '</Exception>', start_position, 1);
xmldata := dbms_lob.substr(r1.xml_data, 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)
can someone help me share how i can use this xpath in oracle pl/sql?
thanks a lot