[Mapserver-users] Oracle spatial error - off topic to mapserver

Tomko tomko at gku.sk
Fri Mar 19 07:00:44 PST 2004


HI,
Sorry for bothering this list, but I am really hopeless. You can write
me directly to avoid spamming the list, if you can help me... PLEASE"

 I am (still)in troubles with Oracle Spatial and I do not 
 know how to get out of them... 

from the beginning I have a strange error occuring - I cannot creat
spatial indices!!! So also the mapserver oraclespatial connection
doesn't work well with the USING SRID... way, I have to do the double
select... And this 
 show as a crucial limitation when I want to use it with other tools
(ArcSDE) or for 
 performance reasons... Maybe you could give me a hint?? here is the
error 
 message (and a sample procedure leading to it): 
 

 CREATE TABLE body (CBODU NUMBER PRIMARY KEY,NAZOV VARCHAR (32),X
NUMBER,Y 
 NUMBER,Z NUMBER,TOPO VARCHAR (32),GEOM MDSYS.SDO_GEOMETRY); 
 commit; 
 
 INSERT INTO USER_SDO_GEOM_METADATA 
 VALUES ( 
 'body', 
 'GEOM', 
 MDSYS.SDO_DIM_ARRAY( 
 MDSYS.SDO_DIM_ELEMENT('X', 0, -591445, 0.005), 
 MDSYS.SDO_DIM_ELEMENT('Y', 0, -1373146, 0.005), 
 MDSYS.SDO_DIM_ELEMENT('Z', 0, 1000, 0.005)), 
 NULL -- SRID 
 ); 
 commit; 
 
create index body_idx on body (GEOM)
2* INDEXTYPE IS mdsys.spatial_index
 
 CREATE INDEX body_idx 
 * 
 ERROR at line 1: 
 ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine 
 ORA-13249: Error executing stmt:  begin
mdsys.prvt_idx.execute_insert(NULL, 
 NULL, ' VALUES (''SYS'',''MDIDX_INIT'', 0, 0, 64, -1,
NLS_UPPER(''MDRT_77D1 
 $''), ''BODY_IDX'', 1, ''SYS'', ''"GEOM"'', 0, 0, 3, 
 0, ''DEFAULT'', ''DEFAULT'', NULL,NULL, NULL, NULL, NULL, NULL, NULL, 
 2, ''DEFAULT'', 10, NULL, NULL, NULL, NULL, ''FALSE'', ''VALID'',
NULL)', 
 NULL); end; 
 ORA-13249: Error in Spatial index: insert to metadata failed 
 ORA-29400: data cartridge error 
 ORA-00913: too many values 
 ORA-06512: at "MDSYS.PRVT_IDX", line 5 
 ORA-06512: at line 1 
 ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7 
 ORA-06512: at line 1

I have also tried to reinstall Oracle for it, but I am having the same
error. The installation did not report any error. I am encountering a
similar error when trying to create spatial tables with ESRI ArcSDE, or
even working with a XML database. I suspect that it is a problem with
the ODCIIndex cartridge or something like that, according to the forums.
I am running a windows version of Oracle 9.2.0.1, a developper version
downloaded from the otn. I am running a Windows 2003 server and I have
updated the universal installer and applied the patch. I did not do any
changes to the MDSYS user, just unlocked it. I was connected as sys.

I have found something about a "catpatch procedure"
But did not run this...

 Thanks a lot! 
 
 Martin




More information about the MapServer-users mailing list