passing parameters to function - Mailing list pgsql-jdbc

From Srivats
Subject passing parameters to function
Date
Msg-id 004101c5e45f$61a3fbd0$851e010a@NBINDIAXP0133
Whole thread Raw
In response to Batch with keygen?  ("Mike Clements" <mclements@actional.com>)
List pgsql-jdbc
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:Incorrect 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
 
 

pgsql-jdbc by date:

Previous
From: "Srivats"
Date:
Subject: passing parameters to function
Next
From: Dave Cramer
Date:
Subject: Re: passing parameters to function