Spatial Data Option and ORA-3113

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Wed, 14 Oct 1998 16:28:13 +0200
Message-ID: <3624B4FD.B55E21D9@datenrevision.de>

Hi,
we get an ORA-3113 (EOF on communication channel) when we use the following statement:

SELECT somevalue
FROM sometable
WHERE
hhidrows('POLYGON',location, -32500, 32500, -32500, 32500 , 1,1,2,2,3,3,4,4,
[snip]...
39,39,40,40,41,41
) <> 'OUTSIDE'

These are 41 pairs of coordinate values. The problem is dependent on the number of pairs, not on the values. On our 7.3.2 Server the limit for successful execution of this statement is 40 pairs. Any bigger number gives us an ORA-3113. On our customers 7.3.4 Server, the limit is 32. Is this a bug in SDO or a known limitation? Is it possible to configure this limit?

Thanks
Rolf Received on Wed Oct 14 1998 - 09:28:13 CDT