Using a ref cursor as input type with ODP.NET?

I'm also in contact with Mark Williams, the author of the article I've tried to link on my post, and he has kinly responded like this.

I'm also in contact with Mark Williams, the author of the article I've tried to link on my post, and he has kinly responded like this: " It is no problem to send me email; however, I think I will disappoint you with my answer on this one. Unfortunately you can't do what you are trying to do (create a refcursor from the client like that). A couple of problems with that are that a refcursor refers to memory owned by Oracle on the server and Oracle has no concept of client items like a DataTable or a .

NET List, etc. Do you have any other options available other than using a refcursor? " So basically I'm screwed, and this question is closed. Thanks for reading and/or trying to help, you all.

From memory, isn't there an OracleCursor class somewhere in the ODP. NET library that works?

(Even if it exists, check that it does what you need it to... my memory is a bit hazy) – jerryjvl Jun 1 '09 at 7:59.

Look at this sample for refcursor as input to pl/sql from oracle technet. The clou is that the input refcursor object must be created by oracle themself. You cannot convert a list or anything else to refcursor.

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.