My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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



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 .


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.