Return resultset from SP

xerg · #1 (**permalink**) 08-11-09, 11:39

Hi guys

, i have a big problem with this requeriment,

I need create a stored procedure with the following structure

In parameters:
String cod
String date

Out Parameters:
String flag
String type

Resultset:
id | name | country

My problem is how can I capture out parameters and resultset from Java, is it possible doing that?????

pd:sorry for my english

n_i · #2 (**permalink**) 08-11-09, 12:21

I think this should help you: Calling stored procedures using CallableStatement methods

xerg · #3 (**permalink**) 08-11-09, 12:58

Thanks n_i!!

Code:

//Register out parameter
cstmt.registerOutParameter (1, Types.INTEGER);   

cstmt.executeUpdate(); 

//getting out parameter
ifcaret = cstmt.getInt(1);

But, if SP also return ResultSet, can I read it in same object "cstmt"??