passing parameters to function

From: "Srivats" <scshekaran(at)riskspan(dot)com>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: passing parameters to function
Date: 2005-11-08 12:31:46
Message-ID: 005901c5e460$6273d980$851e010a@NBINDIAXP0133
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 .

CallableStatement functionCall = dbCon_.prepareCall("{call test1( ?,?,?,?) }");
functionCall.setObject( "param1","A10001" );
functionCall.setObject( "param2","19830529" );
functionCall.execute();

Exception raised

java.sql.SQLException: No value specified for parameter 3
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1253)
at com.mysql.jdbc.PreparedStatement.fillSendPacket(PreparedStatement.java:1201)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:710)
at com.mysql.jdbc.CallableStatement.execute(CallableStatement.java:520)

during runtime. Should i set the other 2 input parameters to null,
even when I dont want to pass these parameters to the SP.
In this statement call test1( ?,?,?,?), should the number of parameters be the number
of parameters which the store procedure accepts or the number of parameters that i want
to pass. How should this be done when my SP accepts 4 parameters and i want to pass
only any two of them

Thks

PS: Looking for an early reply

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nelson Arape 2005-11-08 12:50:14 Re: Batch with keygen?
Previous Message Srivats 2005-11-08 12:24:35 passing parameters to function