Unable To Query Xmltype View ORA-30937 - How To Diagnose Such Errors
Last updated on AUGUST 29, 2010
Applies to:Oracle Server - Enterprise Edition - Version: 126.96.36.199 to 10.1.0.2 - Release: 9.2 to 10.1
Information in this document applies to any platform.
Checked for Relevance on 30-Aug-2010
1 - Relational table created
2 - XML schema registered
3 - Schema-Based XMLType view created based upon the relational table.
Querying the XMLType view fails with the error:
ORA-30937: No schema definition for '%s' (namespace '%s') in parent '%s'
This error is quite generic and does not give an indication of the real cause of this error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms