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:24:35
Message-ID: 004101c5e45f$61a3fbd0$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 .

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

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Srivats 2005-11-08 12:31:46 passing parameters to function
Previous Message Andres Olarte 2005-11-08 00:45:55 Re: Batch with keygen?