ORA-00600 [kqlchg-parent-not-pinned] selecting from view, after referenced package containing sql_ma

Just sharing this info, getting this error. Using database version 19.18 and could not find a reference to this ora-0600 error.

As a workarround you can explicitly compile the view in this situation and the view is working again.

After a datapump import you have to manuallly compile the view to get it working.

In our situation the view and package are more complex, so simplified the problem.

Made a simple test for this error:

CREATE OR REPLACE PACKAGE TEST_MACRO

is

 function get_all_tables ( p_owner in varchar2) return varchar2 sql_macro;

end;

/

CREATE OR REPLACE PACKAGE BODY TEST_MACRO is