how to disable xml validation for XMLTYPE column
Hello,
We have table with XMLTYPE column to store xml files which validates against a Schema (xsd) file. Is there any way to disable this validation as we are not able to insert xml files since upgrading to Oracle 19c.
The table was created as below.
CREATE TABLE xml_data ( FILENAME VARCHAR2(100), xmlFile SYS.XMLTYPE )
XMLTYPE COLUMN "xmlFile" XMLSCHEMA "schema_file.xsd" ELEMENT "xmlElementName";
Please suggest how to alter the table to accept new files without validation. This table already contains old data.
Thanks for your help.