My Oracle Support Banner

Fetching Ref Cursor Fails With Ora 1001 Which Is closed by DBMS_SQL (Doc ID 2365504.1)

Last updated on FEBRUARY 27, 2018

Applies to:

PL/SQL - Version 11.2.0.4 to 12.2.0.1 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

Fetching ref cursor which is closed by dbms_sql will cause Ora 1001.

It can be explained with the help of sample code as below

 

Changes

 Upgraded to 11G.

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!


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