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

[Jiri Potocny]

Martin,

check your USER_SDO_GEOM_METADATA values.
You are supposed to set: MDSYS.SDO_DIM_ELEMENT(coord,xmin, xmax, tol) and
you are assigning 0 to xmin and  -591445 to xmax, but 0 is definitely grater
than -591445.

Try this for example:
INSERT INTO USER_SDO_GEOM_METADATA
    VALUES ( 'body',  'GEOM',
        MDSYS.SDO_DIM_ARRAY(
            MDSYS.SDO_DIM_ELEMENT('X', -592000, -590000, 0.005),
            MDSYS.SDO_DIM_ELEMENT('Y', -1380000, -1370000, 0.005),
            MDSYS.SDO_DIM_ELEMENT('Z', -1000, 1000, 0.005)),
        NULL
);

If that won't solve the problem with creating spatial index, write back
again.

Regards,
Jirka

----- Original Message -----
From: "Tomko" <tomko at gku.sk>
To: <mapserver-users at lists.gis.umn.edu>
Sent: Friday, March 19, 2004 4:00 PM
Subject: [Mapserver-users] Oracle spatial error - off topic to mapserver


>
> 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 &ind ON &tab(&geom) INDEXTYPE IS
       MDSYS.SPATIAL_INDEX PARAMETERS
      ('TABLESPACE=INDX');

> 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
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/mapserver-users