Create Global Temporary Table Of Xmltype = ORA-14457 (Doc ID 1362330.1)

Last updated on SEPTEMBER 27, 2011

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.2 and later   [Release: 11.2 and later ]
Information in this document applies to any platform.

Symptoms

In 11g, the following failure occurs:

SQL> begin
  2    execute immediate '
  3    CREATE GLOBAL TEMPORARY TABLE <TableName> OF XMLTYPE
  4    XMLSCHEMA "<AnXMLSchema>"
  5    ELEMENT "<AnElementName>"' ;
  6  end ;
  7  /
begin
*
ERROR at line 1:
ORA-14457: disallowed Nested Table column in a Temporary table
ORA-06512: at line 2


SQL>
(Where <TableName>, <AnXMLSchema> and <AnElementName> are replaced with appropriate values.)

Note:  This same statement worked in 10.2.0.4.0.

Cause

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