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

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

Postby 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
HolgerS
 
Posts: 2
Joined: Tue 11 Jul 2006 09:34

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

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

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


Return to dotConnect for Oracle