Page 1 of 1

Calling Procedure in Package : Error "OCI No Data" but where are the details

Posted: Fri 19 Jan 2007 14:47
by HolgerS
Hi,

I'm calling a procedure in a Pl/SQL Package which raises an error.


Calling procedure via TOAD I get the message

ORA-01403: No data found
ORA-06512: in "User.Package", Row 251
ORA-06512: in Line 2


Calling the procedure via code and Oracle direct I only get an exception "OCI No Data", inner exception is empty

Any chance to retrieve the original Oracle error message including package name and line numers ??


Thanx
Holger

Posted: Mon 22 Jan 2007 08:46
by Alexey
If it is an error, you should get all the text in OracleException.Message with '\n' delimiters. If it is a warning then all the text may be retrieved via OracleConnection.InfoMessage. If you can't get the text please send us small test project to reproduce the problem; include definition of your own database objects.
Use e-mail address provided in the Readme file.
Do not use third party components.

Posted: Thu 22 Feb 2007 11:20
by kevinherring
Hi Alexey
I too am having this problem, in the OracleException the message is "OCI No Data". However my OracleConnection does not have an 'InfoMessage' property. What am I missing?
I am using version 3.55.16.0.
Thanks
Kevin

Posted: Fri 23 Feb 2007 08:09
by Alexey
Try to use the latest version of OraDirect .NET. If the problem persists, please send me (alexeyi at crlab dot com) small test project with the detailed scenario on how to reproduce the problem.