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

HolgerS · Post by **HolgerS** » Fri 19 Jan 2007 14:47

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

Alexey · Post by **Alexey** » Mon 22 Jan 2007 08:46

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.

kevinherring · Post by **kevinherring** » Thu 22 Feb 2007 11:20

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

Alexey · Post by **Alexey** » Fri 23 Feb 2007 08:09

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.