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: 9.2.0.5 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

Goal

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.

Solution

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