dotConnect can not catch no_data_found exception from Oracle?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
a2z
Posts: 6
Joined: Thu 01 Nov 2012 07:43

dotConnect can not catch no_data_found exception from Oracle?

Post by a2z » Thu 01 Nov 2012 07:48

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?

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Pinturiccio » Thu 01 Nov 2012 12:52

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

a2z
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by a2z » Thu 01 Nov 2012 17:11

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

a2z
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by a2z » Sat 03 Nov 2012 03:50

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

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Shalex » Mon 05 Nov 2012 13:10

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.

a2z
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by a2z » Tue 06 Nov 2012 04:06

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Shalex » Wed 07 Nov 2012 10:30

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.

a2z
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by a2z » Thu 08 Nov 2012 11:26

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Shalex » Tue 13 Nov 2012 16:26

We are investigating the situation concerning ORA-01403.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Shalex » Fri 28 Dec 2012 08:25

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.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Post by Shalex » Thu 17 Jan 2013 17:29

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.

Post Reply