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 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)


While retrieving the results using Managed ODP.NET 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 :



 Oracle Client is upgraded to


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.