Devart Forums

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?

We have reproduced the issue. We will investigate it and notify you about the results as soon as possible.

I am using C# with VS2005, Oracle 10g R2 (10.2.0.5)

Hi,
Was this bug fixed in the version released on 2/11 yet?

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.

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.

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.

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.

We are investigating the situation concerning ORA-01403.

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.

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.