Home » Developer & Programmer » JDeveloper, Java & XML » geting value from xmlType using select extractvalue without validating
geting value from xmlType using select extractvalue without validating [message #216296] Fri, 26 January 2007 04:06
bodoid
Messages: 7
Registered: January 2007
Junior Member
Hi all,
1. i have XML file in xmlType variable

l_xml := xmlType (l_clob,NULL,1,1);

2. i am trying to get value from this file

SELECT EXTRACTVALUE (l_xml,'paymentDetails/bankAccount/bank/bankId') "p" INTO l_buffer FROM dual;


3. i get errors:

ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00202: could not open "http://url/file.dtd" (error 101)

i thing it is because the server is trying to validate XML file with DTD file written in header XML file:
<?xml version="1.0"?>
<!DOCTYPE xxxService PUBLIC "-//xxx/DTD xxx xxxxx xxx//EN" "http://url/file.dtd">)

but the server has no permission to connect the web.

Is there any possibility to disallow validating of XML file?

Thank you all.

Pavel


Previous Topic: dbms_xmlgen / Clob search and replace?
Next Topic: see err : javax.servlet.ServletException: Name jdbc is not bound in this
Goto Forum:
  


Current Time: Mon Dec 05 14:41:25 CST 2016

Total time taken to generate the page: 0.09557 seconds