Have you tried calling oracle sp's using NHibernate? If you have any 
samples please share it.

Can i have both input and output parameter in the stored procedure? 
I'm trying to get resultset thru refcursor using oracle sp. But it is 
not working. 

I'm using NHibernate1.2 and oracle.dataaccess.

Waiting for your feedback at the earliest.