dotConnect can not catch no_data_found exception from Oracle?
dotConnect can not catch no_data_found exception from Oracle?
I am using latest free version of dotConnect for Oracle. When call a store procedure and there is no_data_found exception, I cannot catch that in C#. When I change to Oracle ODP.net, every thing will be fine.
Because of I am using a free version or it is a bug?
Because of I am using a free version or it is a bug?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: dotConnect can not catch no_data_found exception from Oracle?
We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.
Re: dotConnect can not catch no_data_found exception from Oracle?
I am using C# with VS2005, Oracle 10g R2 (10.2.0.5)
Re: dotConnect can not catch no_data_found exception from Oracle?
Hi,
Was this bug fixed in the version released on 2/11 yet?
Was this bug fixed in the version released on 2/11 yet?
Re: dotConnect can not catch no_data_found exception from Oracle?
dotConnect for Oracle raises the OracleConnection.InfoMessage event for ORA-1403 instead of throwing an exception. The reason is that ORA-1403 may be generated in regular situations as well as when a real error occurs. Try using the InfoMessage event and notify us about the results.
Re: dotConnect can not catch no_data_found exception from Oracle?
But I still can catch this with Oralce ODP.Net!!!! For me, it is just a normal exception like divided by zero, or unikey constraints violated ... Why do I need to treat no_data_found in a different way?
Shalex wrote:dotConnect for Oracle raises the OracleConnection.InfoMessage event for ORA-1403 instead of throwing an exception. The reason is that ORA-1403 may be generated in regular situations as well as when a real error occurs. Try using the InfoMessage event and notify us about the results.
Re: dotConnect can not catch no_data_found exception from Oracle?
The ORA-01403 message may be returned in regular situations, like at the end of data fetch. That's why our provider treats it as an informational message. The issue was discussed at http://forums.devart.com/viewtopic.php?f=1&t=16919.
Re: dotConnect can not catch no_data_found exception from Oracle?
I am not satisfied with that. I have catch the exception and raise it again in my package.
Why Oracle ODP.Net treat this as a normal exception but Devart don't.
Why Oracle ODP.Net treat this as a normal exception but Devart don't.
Re: dotConnect can not catch no_data_found exception from Oracle?
We are investigating the situation concerning ORA-01403.
Re: dotConnect can not catch no_data_found exception from Oracle?
The behaviour is changed: ORA-01403 is treated as an information message only for select statements. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
Re: dotConnect can not catch no_data_found exception from Oracle?
New version of dotConnect for Oracle 7.5 is released!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=25664.
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to http://forums.devart.com/viewtopic.php?f=1&t=25664.