My Oracle Support Banner

Package With REF CURSOR Declared in Initialization Part Fails With ORA-06544 [78401]/PLS-00801 [78401] (Doc ID 2218130.1)

Last updated on DECEMBER 19, 2019

Applies to:

PL/SQL - Version 9.2.0.8 and later
Generic (Platform Independent)
*** Checked for relevance on 2nd Jan 2017 ***

Symptoms

Executing a package which has SYS_REFCURSOR/REF CURSOR declared in initialization section fails with ORA-00600 [15419]/ORA-06544 [78401]/PLS-00801 [78401] error.
This happens during the first execution and subsequent execution runs fine.

The following PL/SQL Package, when executed will produce the error.

Error:

ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [78401], [], [], [], [], [], [],[]
ORA-06553: PLS-801: internal error [78401]

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
Cause
Solution


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