dotConnect can not catch no_data_found exception from Oracle?

dotConnect can not catch no_data_found exception from Oracle?

Postby 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?
a2z
 
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
Pinturiccio
Devart Team
 
Posts: 1936
Joined: Wed 02 Nov 2011 09:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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?

Postby a2z » Sat 03 Nov 2012 03:50

Hi,
Was this bug fixed in the version released on 2/11 yet?
a2z
 
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
Shalex
Devart Team
 
Posts: 7542
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
a2z
 
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
Shalex
Devart Team
 
Posts: 7542
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
a2z
 
Posts: 6
Joined: Thu 01 Nov 2012 07:43

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby Shalex » Tue 13 Nov 2012 16:26

We are investigating the situation concerning ORA-01403.
Shalex
Devart Team
 
Posts: 7542
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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
Devart Team
 
Posts: 7542
Joined: Thu 14 Aug 2008 12:44

Re: dotConnect can not catch no_data_found exception from Oracle?

Postby 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.
Shalex
Devart Team
 
Posts: 7542
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle