PL/SQL (MOSC)

MOSC Banner

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.

Tagged:

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