The first three lines of my xml files have a DTD path which gives me an error during load. I am loading the XML using Sqlldr typically using the below
code:
LOAD DATA
INFILE 'filelist.dat'
APPEND INTO TABLE table_xml
(
filename CHAR(128),
xmldata LOBFILE(filename) TERMINATED BY EOF,
sno CHAR(10) "TABLE_XML_SEQ.NEXTVAL",
loaddate SYSDATE
)
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21XML.dtd">
<ichicsr lang="en">
Error:
Record 22: Rejected - Error on table TABLE_XML.
ORA-31020: The operation is not allowed, Reason: For security reasons, ftp and http access over XDB repository is not allowed on server side
If I remove the 2nd line, the load is fine. Any suggestion to deal with this without removing the second line
.i.e. <!DOCTYPE ichicsr SYSTEM "http://eudravigilance.ema.europa.eu/dtd/icsr21XML.dtd">