Re: ORA-1300

"ennio" <ennioj_at_libero.it> schreef in bericht news:1160037674.343959.271040_at_b28g2000cwb.googlegroups.com...
> Hi.....
> I occourred in this Error:
> SELECT SDO_GEOM.SDO_Distance(A.geom,B.geom,0.00005)
> FROM montane A,montane B
> ORA-1300: dimension number out of range
> The number of dimension are two and the table also are at two
> dimension,,,,
> Also it work when i restricted the distance to 0,,,,,
> What the problem?
>

Think you mean ORA-13000. Please be precise... Looks like you're running into an invalid geometry in this query (maybe a singleton?). Try the same query with a where clause, limiting the number of geometries used, this finding the corrupt geometry

Or try this:

SELECT SDO_GEOM.SDO_Distance(A.geom,2, B.geom, 2, 0.00005) FROM montane A,montane B

(explicitly defining the dimension numbers)

or try with a somewhat higher tolerance (0.05)

AND in all cases use where A.id <> B.id (for their distance will be 0)

If all fails: flush your SGA, and rebuild your geometric index on montane. Distance calculations are based on the index. Like I stated before: spatial is somewhat instable...

What platform (OS, DB version) are you on? Especially Spatial is behaving very different on different platforms, different versions

Robbert van der Hoorn
OSA it BV
The Netherlands Received on Thu Oct 05 2006 - 04:08:08 CDT