If you compile a package from a source other than navigator then execute that package with a
You get this error:
ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package “LCAPROGRAMMER.LCA_TLC_UTILITY2” has been invalidated
ORA-04065: not executed, altered or dropped package “XXXXXXXXXXX.LCA_TLC_UTILITY2”
ORA-06508: PL/SQL: could not find program unit being called: “XXXXXXXXXXX.LCA_TLC_UTILITY2”
ORA-06512: at line 5
dbms_output.put_line('RET: ’ || hld_out);
Now if you refresh and get everything current it will not execute any longer all you get is PL/SQL block executed, but nothing is really working. In fact if you do another generic block in the same session for a totally different package it will not run eiter. Attached is a simple package, build it in sqlplus run it in navigator, re build it in sqlplus and try running it in navigator.
Sorry if this has already been reported.
image001.gif (21.2 KB)