Is it possible (in Hibernate 3.05 and Oracle 9.2) to call an Oracle PROCEDURE that has some IN and OUT params including an OUT REF CURSOR.

Hibernte docs (and test cases) seem to suggest that only sprocs that follow the {?=proc()} notation will work. In other words Oracle FUNCTIONs that explicitly return a REF_CURSOR.

Looking at the API there's no way to do something like: callableStatement.registerOutParameter(index, OracleTypes.CURSOR);

Is this correct? if so, is there a workaround for this (turning this PROCEDURE into a FUNCTION is not possible as there are more OUT params I'm interested in besided the REF CURSOR).

Thanks,
MV

simple answer: no

grap session.getConnection() and do procedure with pure JDBC