ORA-00939 - too many arguments for function

From: Luigi Marinucci <remomeiuwantreply.luigi.marinucci_at_yahoo.com>
Date: Tue, 01 Apr 2003 21:33:42 GMT
Message-ID: <WAnia.43475$Jg1.1021871@news1.tin.it>

We're getting this problem querying with large geometries, we've something like:

SELECT MY_GEOM FROM MY_SPATIAL_TABLE WHERE mdsys.sdo_relate ( GEOM,MDSYS.SDO_GEOMETRY ( 2003, null, null, MDSYS.SDO_ELEM_INFO_ARRAY (1,1003,1,941,1003,1,977,1003,1,1015,1003,1,1049,1003,1,1081,1003,1,1099,100 3,1,1127,1003,1), MDSYS.SDO_ORDINATE_ARRAY ...... where the ordinate array may be very large 10-20k

Some tips?

TIA
Luigi Received on Tue Apr 01 2003 - 15:33:42 CST