ORA-600 [15419] in sys_refcursor variable in package initialization block 11.2.0.4.160719
edited Oct 10, 2016 5:00AM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 4 commentsAnswered
Greetings.
I have two databases: 11.2.0.4.160719, 11.2.0.4.4 both SE1.
If I compile pachage
CREATE OR REPLACE PACKAGE foo IS PROCEDURE foo;END foo;/CREATE OR REPLACE PACKAGE BODY foo IS PROCEDURE foo IS BEGIN NULL; END;BEGIN DECLARE v_cur SYS_REFCURSOR; BEGIN OPEN v_cur FOR 'select * from dual'; CLOSE v_cur; END;END foo;/
and execute foo.foo I get ORA-600 [15419].
The problem occures in the OPEN statement of the refcursor in the initialization block.
0