Hai All
I have got a problem in invoking a stored procedure from
java code,
The Java code is:
-----------------
cstmt = connection.prepareCall("{call INSERTUPSDEMO(?, ?, ?, ?, ?)}");
cstmt.setString(1, "SAM");
cstmt.setInt(2, 2000);
cstmt.setInt(3, 250);
cstmt.setInt(4, 3467);
cstmt.registerOutParameter (5, Types.INTEGER);
cstmt.execute();
temp = cstmt.getInt(5); // Get the output parameter values
My Problem:
-----------
The code works fine if i give all the parameters.
But in some cases i may not pass all the parameters,
for example if i dont want to send the parameter4 value,
i.e i want to send a null value into it.
I need to know how to pass a null parameter.
Any help is appreciated,
Thanks in advance,
Pooja