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

Last updated on JANUARY 01, 2017

Applies to:

PL/SQL - Version 9.2.0.8 and later
Information in this document applies to any platform.
*** 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

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 hundreds of Community platforms