Fetching Ref Cursor Fails With Ora 1001 Which Is closed by DBMS_SQL
(Doc ID 2365504.1)
Last updated on MARCH 04, 2022
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |