db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From dag.wan...@oracle.com (Dag H. Wanvik)
Subject Re: Can't run SYSCS_IMPORT_TABLE
Date Mon, 03 Oct 2011 21:37:42 GMT
Tim Watts <tim@cliftonfarm.org> 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

Mime
View raw message