Re: Oracle Spatial: huge mdsys.sdo_geometry

How many points do you have in your polygon. I think the SDO_ORDINATE array is a VARRAY which has a maximim of 1000000 numbers.
This gives you a maximum of 500000 points in your polygons if you have 2D points
and 333333 if you have 3D points in your polygon.

Hans

"Christof Kaiser" <kaiser_at_logiball.deREMOVETHIS> wrote in message news:3B1E42F2.114A9D14_at_logiball.deREMOVETHIS...
> Hi,
>
> using Orcale 8i (Spatial) to store polygons I got a problem when these
> are getting fairly big (in terms of the SDO_ORDINATES array).
> I can build the polygon, but when retrieving it I get a
> ORA-22813: operand value exceeds system limits.
>
> Also, trying to SDO_RELATE it with another polygon, the SELECT (where
> the relate is in) never comes back.
> An exception would be fair, but not giving back the control flow (for
> hours) is indeed nasty.
>
> Any comments appreciated.
>
> Regards
>
> Christof
>
Received on Thu Jun 07 2001 - 02:09:30 CDT