XML Database (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center