ORA-24338 and REFCURSOR

[dave_93_98]

I am receiving the above error (ORA-24338 statement handle not
executed) when an exception is thrown from the stored procedure I am
calling. One of the arguments to this procedure is an output parameter
containing a refcursor, which I suspect is the problem. Has anyone else
encountered this, if so is there a workaround? I am using Visual Studio
2005, the Oracle 9.2 client, and System.Data.OracleClient version
2.0.50727.

Thanks,
Dave

 

[Paul Clement]

On 9 Nov 2006 08:20:21 -0800, (e-mail address removed) wrote:

¤ I am receiving the above error (ORA-24338 statement handle not
¤ executed) when an exception is thrown from the stored procedure I am
¤ calling. One of the arguments to this procedure is an output parameter
¤ containing a refcursor, which I suspect is the problem. Has anyone else
¤ encountered this, if so is there a workaround? I am using Visual Studio
¤ 2005, the Oracle 9.2 client, and System.Data.OracleClient version
¤ 2.0.50727.

I haven't seen this error before but you may want to post your code so we can see what the procedure
call and parameters look like.


Paul
~~~~
Microsoft MVP (Visual Basic)