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

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
HolgerS
Posts: 2
Joined: Tue 11 Jul 2006 09:34

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

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
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

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
Posts: 64
Joined: Wed 04 Jan 2006 15:32

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
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

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.

Post Reply