Repeat after me:
"Never use the SYS schema for testing - it behaves differently from any
other schema"
Stil, interesting difference in the compile.
Regards
Jonathan Lewis
On Fri, 30 Oct 2020 at 16:21, Noveljic Nenad <nenad.noveljic@xxxxxxxxxxxx>
wrote:
I reproduced the error by running the procedure under a non-sys user. Sys
might be exempted from ORA-04036.
I had to put fill_memory at the end of the body to compile it under a
non-sys user. Under sys this wasn’t necessary. This might indicate that the
compiler makes two passes when compiling sys objects and only one pass for
non-sys.
With every mistake we learn something new. This time, the luck was double.
