Hi, apologies if this has been answered a thousand times. I tried a search and couldn't see the answer (except maybe in German....)

We are interested in transitioning to using Hibernate to execute our Oracle queries.
Can Hibernate run an Oracle stored procedure and take a result set from it using refcursors?

We have a strong desire to keep all SQL in the database itself (where I would argue that it belongs) and return result sets more suitable to Objects and classes via stored procedures.

Thanks
Mark

it is covered in the manual.

look for stored procedures.