spatial on 10g...

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 16 Nov 2005 18:42:53 +0100
Message-ID: <dlfr2t$5rl$1@nntp.fujitsu-siemens.com>

Hi!
Does somebody have spatial running on 10g and can try the following script for me?

create global temporary table TST_PARTS

	(
	REFDes varchar(10) not null,
	BZP mdsys.sdo_geometry not null,
	primary key (REFDes)
	);
insert into USER_SDO_GEOM_METADATA


		(table_name, column_name,diminfo,srid)

	values


		(

		'TST_PARTS',
		'BZP',
		 MDSYS.SDO_DIM_ARRAY(MDSYS.SDO_DIM_ELEMENT('X',-1000,1000,0.00001),MDSYS.SDO_DIM_ELEMENT('Y',-1000,1000,0.00001)),
		 NULL
		 );

create index TST_PARTS_IDX1 on TST_PARTS(BZP) indextype is mdsys.spatial_index parameters ('layer_gtype=POLYGON');

9i gives me an error saying that it can't handle varrays or nested tables in temporary tables and I'd like to know whether either it can now or spatial works around it somehow.

Lots of Greetings and thanks!
Volker Received on Wed Nov 16 2005 - 11:42:53 CST