Hi,

I need to implement a Stored Procedure in Hibernate, my code using connection class is this:

cs = conn.prepareCall("{call PROCEDURE (?,null,?,?,?)}");
cs.setString(1,custcode);
cs.registerOutParameter(2, Types.NUMERIC);
cs.registerOutParameter(3, OracleTypes.CURSOR);
cs.registerOutParameter(4, OracleTypes.CURSOR);

I've found some examples where return specific values, but I don't know how to return a Cursor Type, Is it possible with Hibernate and if it's true how to, or this is not possible to implement and I need to use connection class? I hope your help.

Thanks in advance,

Fernangps

Get the connection from the hibernate session and use JDBC (as you have shown).

see http://www.oracle.com/technology/sample ... index.html