Re: Reproducing ORA-04036

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_at_vontobel.com> 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.
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l