My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Data Provider for .NET - Version 9.2.0.4.0 to 11.1.0.7
Microsoft Windows (32-bit)

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 .



Changes

 

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!

In this Document
Symptoms
Changes
Cause
Solution
References

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