Retrieving returned value from stored proc

ajit · July 14th, 2006, 08:43 AM

i have a stored proc that returns some value using return keyword(Not out put parameter). I am executing the stored proc using CallableStatement object. How can i retrieve the returned value from stored procedure. Ex Procedure could be as below

Code:

create procedure sp_Test
as
    declare LV_TestVar int
    if exists (select * from A)
          set LV_TestVar = -1
        return LV_TestVar

how can i retrieve the LV_TestVar using CallableStatement?.

Regards

Ajit

elishae · August 29th, 2006, 09:49 AM

either you can add output param for procedure, or make it a function for returning values.

and then execute the following code

Code:

CallableStatment cs = con.prepareCall({call sp_Test});
ResultSet rs = cs.executeQuery();
rs.getInt(1);