Tim Watts <[email protected]> writes: > java.sql.SQLSyntaxErrorException: > 'SYSCS_UTIL.SYSCS_IMPORT_TABLE' is not recognized as a function > or procedure. > > whenever I try to execute this code: > > String statement = "CALL SYSCS_UTIL.SYSCS_IMPORT_TABLE > (?,?,?,?,?,?,?,?,?)";
> I saw on the wiki that, at least on earlier versions, this could occur > if I didn't have the correct number of parameters. Yup. > But I believe I'm > passing the right number (9). The procedure does in fact exist according > to ij's "show procedures" command. Any ideas what I'm doing wrong? No. This procedure has seven arguments. The one that has nine is SYSCS_UTIL.SYSCS_IMPORT_DATA. (i.e. *_TABLE vs, *_DATA). Hope this helps, Dag
