Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Disable Schema validation in XMLTYPE Column

566769Jun 27 2007
Hi all!

I have created the following table with an Schema-based XMLTYPE column:

CREATE TABLE ADR1 (
idnr NUMBER,
FileType XMLTYPE,
constraint pk_idnr primary key (idnr))
XMLTYPE COLUMN FileType STORE AS CLOB
XMLSCHEMA "http://localhost:8080/home/usr/xsd/cc.xsd"
ELEMENT "File";

Now i want to disable the schema - validation for the XMLTYPE Column. I have done this before for an XMLTYPE Table. But in this case of an XMLTYPE Column i cant find the Constraint, that belongs to the Column.

Thanks for your help!

Axel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2007
Added on Jun 27 2007
0 comments
735 views