OraFAQ Forum: JDeveloper, Java & XML » geting value from xmlType using select extractvalue without validating

Home » Developer & Programmer » JDeveloper, Java & XML » geting value from xmlType using select extractvalue without validating

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 08:51:57 CDT 2024