I am using this method to insert into table of xmltype
INSERT INTO xml_table
VALUES (XMLType(bfilename('XMLDIR','Test_xml.xml'),
nls_charset_id('AL32UTF8')));
xmlfile is like this
<?xml version="1.0" encoding="ISO-8859-1"?><!DOCTYPE metadata SYSTEM "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd"><metadata>
<idinfo>
<citation>
<citeinfo>
<origin>MRF</origin>
<pubdate>20040512</pubdate>
<pubtime>08305555</pubtime>
<title>BAS_STREET_SEGMENT</title>
<edition>1</edition>
<geoform>vector digital data</geoform>
<serinfo>
<sername>one</sername>
ERROR at line 2:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00202: could not open "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd"
(error 101)
Error at line 1
ORA-06512: at "SYS.XMLTYPE", line 295
ORA-06512: at line 1
I need to used dtd validation, i cannot turn off dtd, is there anyway that i can use dtd validation in oracle.I read a white paper
which says that while inserting into xmltype dtd validation is supported.
db version is Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
&
client i am using there is internet connection, and database server is on different machine(without internet), this file "http://www.fgdc.gov/metadata/fgdc-std-001-1998.dtd" is available on internet.
Pl help, thankx