call to oracle sp

[Tina Ljuslin]

Hi,
I'm trying to make a call from a servlet to an oracle stored procedure. The first two parameters in the sp are IN parameters and works fine, but the third one is an OUT parameter and doesn't work.
I have tried:
String sql = "{call udcts_pkg.sp_checkUpdateStatusUser('INparam1', 'INparam2', outparam)}";
but get the exception:
java.sql.SQLException: ORA-06550: line 1, column 56: PLS-00201: identifier 'OUTPARAM' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored
if I try:
String sql = "{call udcts_pkg.sp_checkUpdateStatusUser('INparam1', 'INparam2', utparam)}";
I get the exception:
java.sql.SQLException: ORA-01008: not all variables bound }
Does anyone know how to make the call correct?
//tina

[Tina Ljuslin]

I was totally wrong and know how to do it now.
call = con.prepareCall( "{call udcts_pkg.sp_checkUpdateStatusUser( ?, ?, ?)}" );
call.setString( 1, 'inparam1');
call.setString( 2, 'inparam2' );
call.registerOutParameter( 3, Types.VARCHAR );
thanks anyway
//tina