Home » Server Options » Spatial » Oracle Spatial
Oracle Spatial [message #75824] Mon, 23 February 2004 01:20 Go to next message
Ravi
Messages: 251
Registered: June 1998
Senior Member
Hi, I am trying to run the following query which throws the error message. Any help in this regard would be highly appreciated.

SELECT A.ROWID,A.SPATIALANY FROM FENCE A WHERE SDO_GEOM.RELATE(A.SPATIALANY,'ANYINTERACT',(SELECT SDO_GEOM.SDO_MBR B.SPATIALANY) FROM FEATURES B WHERE B.ID=7),0.000005)='TRUE'

Note: The DIMINFO for both Tables is same in USER_SDO_GEOM_METADATA.

ERROR:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "MDSYS.SDO_GEOM", line 68
ORA-06512: at "MDSYS.SDO_GEOM", line 3213

no rows selected.
Re: Oracle Spatial [message #154453 is a reply to message #75824] Sun, 08 January 2006 15:30 Go to previous message
dfuhry
Messages: 1
Registered: January 2006
Location: Cleveland, OHio
Junior Member
Check to make sure none of the geometries have a null SDO_GTYPE. A query of mine to to compute centroids of 500,000 polygon geometries was failing because just a few of them were empty like this:

SDO_GEOMETRY(NULL, 41100, NULL, SDO_ELEM_INFO_ARRAY(), SDO_ORDINATE_ARRAY())

giving this error:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "MDSYS.SDO_GEOM", line 70
ORA-06512: at "MDSYS.SDO_GEOM", line 3328

Changing the query to only affect rows
WHERE [tablename].[geometry column].SDO_GTYPE IS NOT NULL
did the trick.

-Dave
Previous Topic: Data Type: Spatial
Next Topic: Create DWG from SDO_GEOMETREY
Goto Forum:
  


Current Time: Thu Mar 28 16:17:33 CDT 2024