SQLLOADER load XML, checking with DTD but not load DTD in DB
Hello guys,
I load with SQLLOADER in xmltype column of table. I load my DTD files in XDB repository. So if I load below xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE LocationDesc SYSTEM "/public/TestDesc.dtd">
<TestDesc>
Sqlloader load and check xml by DTD but after it load DTD data with xml data in field - but I don;t need DTD data in my column - I want only checking during loading.
So if erase <!DOCTYPE LocationDesc SYSTEM "/public/TestDesc.dtd"> it load and don't check any DTD checking - it's clear.
So how can I tell sqlploader or write in xml file or when create table with xmltype that - store xml - check during sqlloader DTD - but don't store this DTD with my XML data after successfully loading.