ORA-1000 Using ODP.NET and Procedures That Return Multiple Ref Cursors (Doc ID 789006.1)

Last updated on JULY 05, 2017

Applies to:

Oracle Data Provider for .NET - Version 9.2.0.4.0 to 11.1.0.7
Microsoft Windows (32-bit)
***Checked for relevance on 29-Jan-2013***

Symptoms

 

Calling a stored procedure that returns multiple ref cursors (3 or more) via the OracleDataProvider for .NET (ODP.NET) using ExecuteReader can leak cursors if all the ref cursors are not touched via calling NextResult, resulting in the following error:


Oracle.DataAccess.Client.OracleException ORA-01000: maximum open cursors exceeded


This behavior does not occur when using ExecuteNonQuery and accessing the ref cursors directly via parameters .



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