Home » Developer & Programmer » JDeveloper, Java & XML » XMLTYPE, Error Create Table with XMLTYPE using Oracle 9.0.1.1.1
XMLTYPE, Error Create Table with XMLTYPE using Oracle 9.0.1.1.1 [message #249460] Wed, 04 July 2007 10:02 Go to next message
thamer_nma
Messages: 1
Registered: July 2007
Junior Member
Hi,

plz i need your help.

i install the oracle 9.0.1.1.1 on my server (windows server 2003). then i want to create a table with type XMLTYPE but i had an error (ORA-00902: invalid datatype)

here is my script:

CREATE GLOBAL TEMPORARY TABLE TEMPXML OF XMLTYPE
ON COMMIT PRESERVE ROWS
NOCACHE;

thanks for all. Smile
Re: XMLTYPE, Error Create Table with XMLTYPE using Oracle 9.0.1.1.1 [message #249772 is a reply to message #249460] Thu, 05 July 2007 17:54 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
SQL> show user
USER is "ORACLE"
SQL>  select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE    10.2.0.3.0      Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

SQL>  CREATE GLOBAL TEMPORARY TABLE TEMPXML OF XMLTYPE
  2   ON COMMIT PRESERVE ROWS
  3   NOCACHE;

Table created.

SQL>


Is it allowed to create temp table with XML option in ORACLE 9.0.1.1.1 ?????????
Re: XMLTYPE, Error Create Table with XMLTYPE using Oracle 9.0.1.1.1 [message #251289 is a reply to message #249460] Thu, 12 July 2007 16:02 Go to previous message
mchadder
Messages: 224
Registered: May 2005
Location: UK
Senior Member
Hi,

no, you couldn't create tables of XMLTYPE until 9i release 2.

http://download-uk.oracle.com/docs/cd/B10501_01/appdev.920/a96620/whatsnew.htm

Regards
Previous Topic: Need ADF Swings Deployment Documentation In Oracle Application Server
Next Topic: XML Formatting
Goto Forum:
  


Current Time: Sat Dec 14 14:50:48 CST 2024