Executing a Long Running Query with CommandTimeOut set in a .NET Application using ODP Fails With: Exception: System.AccessViolationException (Doc ID 1317550.1)

Last updated on MAY 23, 2013

Applies to:

Oracle Data Provider for .NET - Version 10.2.0.2 and later
Generic Windows
***Checked for relevance on 22-May-2013***

Symptoms

Executing a long running query with CommandTimeOut set in a .NET application using ODP may fail with:

Exception: System.AccessViolationException

Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

The top of the StackTrace may look similar to the following:

at Oracle.DataAccess.Client.OpsSql.Timeout(OpoSqlValTimeoutCtx& opoSqlValTimeoutCtx)
at Oracle.DataAccess.Client.OracleCommand.Timeout(Object state)
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.runTryCode(Object userData)

Changes

Upgraded the Oracle Data Provider for .NET to version 10.2.0.2.20

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