ORA-24338: statement handle not executed
414903Aug 25 2004 — edited Aug 26 2010Hi,
I'm trying to get a ref cursor from a stored procedure, in the stored procedure I validate the parameters if the parameters are wrong I raised an error using :
raise_application_error(-20001, 'Error Message')
or
raise a custom exception,
when I catch the Exception in C# I expect to get my custom error message, instead i get the : "ORA-24338 : statement handle not executed"
My question is : How to propagate customs errors/exceptions in PL/SQL stored procedures/functions to the .net client.
I'm using Oracle 9.2 and ODP version 9.2.0.2
Thanks a lot for your help !