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!

Are Schema Validation Errors Always Prefixed with LSX-?

478454Jan 3 2006 — edited Jan 4 2006
Hi,

I'm validating an xml document against a schema document by way of a trigger on an xmltype table/column using schemavalidate(). I am trapping the error stack via an exception handler and would like to attempt to record only the part of the error stack that is pertinent to why the validation failed. This seems to always be the portion prefixed with LSX-, as in the following:

ORA-31154: invalid XML document
ORA-19202: Error occurred in XML processing
LSX-00213: only 0 occurrences of particle "TransactionCode", minimum is 1
ORA-06512: at "SYS.XMLTYPE", line 0
ORA-06512: at "UIMSMGR.U$_UXTSOTR_DB", line 4
ORA-04088: error during execution of trigger 'UIMSMGR.U$_UXTSOTR_DB'

Based on the 9iR2 documentation, I am led to believe that the validation errors always begin with LSX-.

Does anyone know of this to be the case for sure?

Thank you.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2006
Added on Jan 3 2006
8 comments
1,653 views