Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00939 - too many arguments for function

361066Apr 1 2003 — edited Nov 9 2004
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,1003,1,1127,1003,1), MDSYS.SDO_ORDINATE_ARRAY ......

where the ordinate array may be very large 10-20k

Some tips?

Best regards
Luigi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2004
Added on Apr 1 2003
#database-key-features, #spatial
7 comments
1,552 views