Unable To Query Xmltype View ORA-30937 - How To Diagnose Such Errors

(Doc ID 276824.1)

Last updated on AUGUST 29, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 9.2 to 10.1
Information in this document applies to any platform.
Checked for Relevance on 30-Aug-2010


Imagine the following construction:

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms