Can Hibernate handle multiple cursors returned by Stored Procedure?

Hibernate version:3.0

Name and version of the database you are using:Oracle 10g

No, a stored procedure has to return a result set as first out parameter in order to be usable in hibernate.

double post, don't know why, as I clicked only once and saw only one post made.... seems to be a problem today...

double post...

ya, you are right I've done my previous task like this. But my question is if I want to return two ResultSet from a SP then what to do ?

Suppose I want to return an employee details and the corresponding department details of that employee, where 1st ResultSet holds the employee details and 2nd one is for department details.

my sp is like this -

SP_EMP_DTLS
( emprec OUT REF_CURSOR,
deptrec OUT REF_CURSOR,
empno IN varchar2) is
begin
.....
.....
end;

How do I get emprec and deptrec, both the resultset in java class ?

As employee-department is a many to one relation you can return both in a single result set. ie an outer join record.