How to use NHibernate to process multiple resultsets/SYS_REFCURSOR from Oracle stored procedure

Question

I can get NHibernate (v2) to return and process a single SYS_REFCURSOR that contains my single resultset. Is it possible for multiple resultsets/SYS_REFCURSOR's in NHibernate? What would be the syntax of the .hbm.xml file to map multiple resultsets from the SYS_REFCURSOR's?

thanks.

Answer 1

I am fairly sure the answer is no, this isn't possible. You have two options to work around this: use a MultiQuery against two stored procs to batch the calls or 2) use the database connection and ADO.NET.