Database Software

Hi everybody,

I encounter a problem when creating a sdo_geometry with many surfaces and met the problem as :ORA-00939: too many arguments for function 00939. 00000 - "too many arguments for function"

To be more precise, in our work, we generate certain points to form a solid or a multi-surfaces as a query shape to perform SDO_ANYINTERACTION. However, there are many surfaces involved. I used the following function, where the number of surface is 20, it works fine. When i use 30 or 60 surfaces with corresponding sdo_elem_info_array and sdo_ordinate_array, it would not work with the error mentioned above.

SELECT CB.NAME name FROM DEMO_3D CB where SDO_ANYINTERACT(CB.GEOM, SDO_GEOMETRY(3007, 2157, NULL, SDO_ELEM_INFO_ARRAY(1,1006,20, 1, 1003, 1,37, 1003, 1,73, 1003, 1,109, 1003, 1,145, 1003, 1,181, 1003, 1,217, 1003, 1,253, 1003, 1,289, 1003, 1,325, 1003, 1,361, 1003, 1,397, 1003, 1,433, 1003, 1,469, 1003, 1,505, 1003, 1,541, 1003, 1,577, 1003, 1,613, 1003, 1,649, 1003, 1,685, 1003, 1,721, 1003, 1,757, 1003, 1,793, 1003, 1,829, 1003, 1,865, 1003, 1,901, 1003, 1,937, 1003, 1,973, 1003, 1,1009, 1003, 1,1045, 1003, 1,1081, 1003, 1,1117, 1003, 1,1153, 1003, 1,1189, 1003, 1,1225, 1003, 1,1261, 1003, 1,1297, 1003, 1,1333, 1003, 1,1369, 1003, 1,1405, 1003, 1), SDO_ORDINATE_ARRAY(.....................................)))='TRUE';

Right now, we are using Oracle 11g release 1
Does anybody know if there is any restriction specifying how many surfaces we can have in the SDO_ELEM_INFO_ARRAY, or something else. Thanks in advance.

--------------------------------------update----------------------------------
I had just tested, the total number allowed is 27 surfaces in the SDO_ELEM_INFO_ARRAY and SDO_ORDINATES. Thanks

Best Regards
Junjun

Edited by: Junjun on Oct 21, 2010 2:57 PM