PostgreSQL JDBC - passing parameters to function

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

passing parameters to function

Srivats

2005-11-08, 4:12 pm

Hi All,

Suppose I have a store proc which accepts 4 input parameters
and I do a CallableStatement.setObject( 1, "..,,," );
and execute the query .

It gives me that number of arguments need 4, but found only 1

(java.sql. SQLException:Incorre
ct number of arguments for PROCEDURE FHLMC.test1; expected 4, got 1)

during runtime. Should i set the other 3 input parameters to null,
even when I dont want to pass these parameters to the SP.

Thks

Sponsored Links