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: 220.127.116.11
Information in this document applies to any platform.
2 execute immediate '
3 CREATE GLOBAL TEMPORARY TABLE <TableName> OF XMLTYPE
4 XMLSCHEMA "<AnXMLSchema>"
5 ELEMENT "<AnElementName>"' ;
6 end ;
ERROR at line 1:
ORA-14457: disallowed Nested Table column in a Temporary table
ORA-06512: at line 2
Note: This same statement worked in 10.2.0.4.0.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document