Hi All,

I have a stored procedure that returns a integer value and a ResultSet. How to get the integer value ?
--------
- SQL --
--------
CREATE PROCEDURE ADMINISTRATOR.test1 ( )
DYNAMIC RESULT SETS 1
P1: BEGIN
DECLARE cursor1 CURSOR WITH RETURN FOR
SELECT PROCSCHEMA, PROCNAME FROM SYSCAT.PROCEDURES; ---RETURN ResultSet
OPEN cursor1;
RETURN 1; --- how to get this value ????????????????
END P1

//
// java code
//
Connection con = connectSQL();
String execRPC = "{call ADMINISTRATOR.test1() }";
CallableStatement scs = con.prepareCall(execRPC);
scs.execute();

// -----------------

How to get the RETURN value? Pls help.

your call needs to look like this:

//
// java code
//
Connection con = connectSQL();
String execRPC = "{? = call ADMINISTRATOR.test1() }";
CallableStatement scs = con.prepareCall(execRPC);

I believe you need to register it as an out parameter.

Andy

Thank andy!

it works fine.

pan_21cn