Create Global Temporary Table Of Xmltype = ORA-14457
Last updated on SEPTEMBER 27, 2011
Applies to:Oracle Server - Enterprise Edition - Version: 188.8.131.52
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.
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