Managed ODP.NET Driver Does Not Cancel Running Queries Using OracleCommand.Cancel() (Doc ID 2174904.1)

Last updated on AUGUST 23, 2016

Applies to:

Oracle Data Provider for .NET - Version 12.1.0.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

While retrieving the results using Managed ODP.NET 12.1.0.2 driver, if OracleCommand.Cancel() method is called, the method is ignored and program execution completes successfully.
Unmanaged ODP.NET driver will stop execution as expected.

Sample code is shown below -

 

Database Script :

 

Changes

 Oracle Client is upgraded to 12.1.0.2

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms