JDBC and stored procedures

I am trying to call a stored procedure via JDBC.

My code is :

|| CallableStatement cs = conn.prepareCall("{? = call
essai.CHERCH_PROD(?)}");
|| cs.setString(1, code);
|| cs.executeQuery() ;

in fact, my procedure is a fonction and it runs without problem. I am expecting to retrieve the exit value of the function with the method cs.getString(1).

When, i'm runnig this application i have the error : ORA-01008: not all variables bound.

Could someone see the problem and explain me what i made wrong.

Thanks for your help. Received on Wed Apr 07 1999 - 11:11:38 CDT