I have not tested this with a function, but for my stored procedures. I specify the out parameter for the refCursor.
I have not tested this with a function, but for my stored procedures. I specify the out parameter for the refCursor. Command.Parameters.
Add(new OracleParameter("refcur_questions", OracleDbType. RefCursor, ParameterDirection. Output)); If you are able to get the function to work with the CommandType.Text.
I wonder if you can try adding the parameter above except with the direction as: ParameterDirection. ReturnValue I am using Oracle. DataAccess version 2.111.6.0.
I've tried several alternatives – Conrad Frix Feb 22 at 16:19 @Conrad Frix I believe you can assign it any name you want, by specifying the parameter direction as return value it would map the results, I haven't tested this yet. I also came across this link return ref_cursor from function. They use ExecuteNonQuery and access the cursor via the parameter.
Is this the alternative way you found? – Peter C Feb 22 at 18:16 that did it. Enjoy your revival badge – Conrad Frix Feb 22 at 20:07 The alternative that I found was to use the procs directly and forget about writing wrapper functions.
See the bottom of this question – Conrad Frix Feb 22 at 20:18 @Conrad Frix Yay I have two badges now =). Thank you! – Peter C Feb 227 at 18:35.
My guess is that you cannot call a function with a Command object of type 'StoredProcedure'. Can you try a Command object of type 'Text' and exec the function within the Command Text?
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.