NHibernate to access Oracle stored procedure REFCURSOR and output parameter?

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.

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.

I found a solution to call old stored procedures with N I don't think that is the better way, but we normally don't have time to refactor everything, so: using (ITransaction transaction = _session. BeginTransaction()) { IDbCommand command = new OracleCommand(); command. Connection = _session.

Connection; command. CommandType = CommandType. StoredProcedure; command.

CommandText = "pk_package. Pr_procedure"; // Set input parameters var param1 = new OracleParameter("@param1", OracleDbType. Decimal) {Value = someField}; var param2 = new OracleParameter("@param2", OracleDbType.

Decimal) {Value = 1}; command.Parameters. Add(param1); command.Parameters. Add(param2); // Execute the stored procedure command.ExecuteNonQuery(); transaction.Commit(); }.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.