Hi

could you pls tell me how can I call a stored procedure in Sybase

I hav a stored procedure with name "MID_EXTRACT_FILE"

that increments a sequence number and stores it in a tablw with current date.

When I call this in the sql prompt ie

just typing MID_EXTRACT_FILE The procedure works

But when I call this using java I doenot work and even doenot produce any error message

My code is below

.....creating connection con....

CallableStatement callst=null;



try

{

callst=con.prepareCall("{call MID_EXTRACT_FILE}");

callst.execute();

}

catch(Exception e)

{

out.println("

Error on Callable Statement (Stored Procedure)

could you pls tell me what is the problem

I ma using sybase version 11.5


Pls note that nmy procedure doenot accept any parameter

thanks in advance


sabu