My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.