Message-ID: <3B1E42F2.114A9D14@logiball.deREMOVETHIS>
Date: Wed, 06 Jun 2001 16:49:22 +0200
From: Christof Kaiser <kaiser@logiball.deREMOVETHIS>
Organization: Logiball Gmbh
X-Mailer: Mozilla 4.73 [en] (WinNT; U)
X-Accept-Language: de-DE,en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.misc
Subject: Oracle Spatial: huge mdsys.sdo_geometry
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 18
NNTP-Posting-Host: 193.97.215.143
X-Trace: 991838982 businessnews.de.uu.net 14100 193.97.215.143
X-Complaints-To: abuse@de.uu.net


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