| Oracle Spatial [message #75824] |
Mon, 23 February 2004 01:20  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
