Output parameters problems

Edson Carlos Ericksson Richter richter at viaapia.com.br
Sun Jul 2 11:17:54 EDT 2000


Can anyone send me a sample using a CallableStatement, using a prepareCall( String ).

I'm using this to call a StoredProcedure, but the statement fails when I call execute (always returns false), and output parameters are not modified.

My code is:

...
      String proceed = new String( "N" );
      cl = cn.prepareCall( "PR_Login ?, ?, ? OUT " );
      cl.setString( 1, username );
      cl.setString( 2, password );
      cl.setString( 3, proceed );

      boolean result = cl.execute( );
...

The variable proceed have their value not modified to S
My stored Procedure was created with the following script:

create procedure PR_Login (@username varchar(15), @password varchar(15), @proceed char(1) output)
AS

  select @proceed = 'S'

Thanks for anyone that can help-me.


Edson Richter




More information about the FreeTDS mailing list