Disable XML Validation (with default table defined in schema)
933216Jun 14 2012 — edited Aug 30 2012Hi,
Is there a way to disable validations when an XML is put into a XMLType table?
I have registered my XML as,
vsql := 'BEGIN
DBMS_XMLSCHEMA.registerSchema(
SCHEMAURL => ''ETV_EPG.xsd'',
SCHEMADOC => bfilename(''MYDIR'',''MY_XSD.xsd''),
OWNER => ''EPGMANAGER'',
CSID => nls_charset_id(''AL32UTF8'')
);
END;';
And my XSD has the following,
<xs:element name="Data" type="ProgramGuide" xdb:defaultTable="MY_TAB" />
which causes any XML file (which adheres to MY_XSD) which I FTP to Oracle be ingested to MY_TAB.
However my XSD has several Key and Keyref elements which causes a lot of validations to take place and slows down the ingest. I want to skip those validations as I am confident that the XML conforms to the schema.
Thanks in advance,
Vishal