ORA-00939: too many arguments for function
393061Apr 23 2003 — edited Apr 12 2010Hi everyone,
I am trying to insert 20k of x-y coordinates into oracle spatial database using JDBC connection and it complains with "ORA-00939: too many arguments for function" message.
I understand there is a limit up to 999 arguments would be passed into SQL statement and that's why I am getting above error message.
Is there anyway I can put in more than 20k of data using JDBC connection? 20K of data is not big enough to hold boundaries or other polygons.
The following is Java code for inserting my data.
-----------------------
String sql_query = "insert into " + table_basin_sdo_write + " (basin_id, geometry) " + "values " + "( " + basin_id + ", mdsys.sdo_geometry" + "( " + "2003, " + "8256, " + "null, " + "mdsys.sdo_elem_info_array(1, 1003, 1), " +
"mdsys.sdo_ordinate_array( " + xy_coord + " )" + ")" + ")";
db_stmt_to.executeUpdate(sql_query);
---------------------------
where xy_coord is a string that holds 20k of data.
Thank you in advance
Jaeyoung Suh
PPDM Association