OracleQueue problem

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Posts: 15
Joined: Fri 30 Apr 2010 11:06

OracleQueue problem

Post by alexB » Wed 08 Aug 2012 13:13


I found a problem while having this scenario:

- make sure that your queue table is empty
- execute the method OracleQueue.Dequeue(OracleQueueDequeueOptions) while a ThreadAbortException occurs.
- in the Catch block call OracleQueue.Connection.Rollback()

Result: the execution will stay blocked forever while trying to execute the Rollback operation.

DotConnect for Oracle version 7.0.6
My Oracle: Oracle Database 10g Express Edition Release - Product

I send you a test project that will reproduce the problem.

Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: OracleQueue problem

Post by Pinturiccio » Wed 15 Aug 2012 13:23

We have reproduced the issue in direct mode. We will investigate it and notify you about the results as soon as possible. As a workaround, you can use OCI connection mode.

Post Reply