NHibernate to access Oracle stored procedure REFCURSOR and output parameter

Question

Does the current version of NHibernate (v2.1.2) support access Oracle stored procedure output REFCURSOR in addition to an output parameter?

I can access the output refcursor fine with my code. However i'm not sure i can access the additional output param in the same stored procedure.

Some sample of calling syntax would be greatly appreciated. thanks.

Answer 1

Nope it does not. Only one refcursor is supported and it has to be the first parameter in the sproc.

You can always get the IDbConnection from the session and then use plain ODP.Net for such scenarios (you lose nh functionality) or rather change the stored procedure.