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!

Validating elements in an XMl file against the XSD

490579Mar 24 2006 — edited Apr 20 2006
Hi,

I have a problem in validating an XML file against an XSD registered in the DB .I have elements in my XML file that are of datatypes integer, long etc.When I load an XML file with invalid data , say 'abcd' for an element whose datatype is integer,I do not get an error while validating it using schemaValidate() in the insert trigger of the XML table.

I need to know how to validate the elements in the XML file for valid data.

Please help.

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2006
Added on Mar 24 2006
10 comments
572 views