Insert Large MDSYS.SDO_ORDINATE_ARRAY
319250Apr 29 2003 — edited Apr 30 2003hi,I have a polygon which has 220 vertices,but if I write the insert SQL statement which will be very long,it will always return a ORA-00907 missing right parenthesis ERROR.
I think because the insert statement is too long that cause this ERROR,so what I should do? Thanks.
and I use the same statement,if the vertices are less,the statement works.
The Statement is like below:
insert into y values (2 ,'test' ,102000,4,MDSYS.SDO_GEOMETRY(2003,NULL,NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,1),MDSYS.SDO_ORDINATE_ARRAY(here contains 220 vertice)));