Re: Missing Grant on Package Body

This may be version-dependent and feature/parameter dependent, but even dumping an errorstack (on 942) at level 1 I found the following pair of consecutive lines in my trace file:

about to signal 942
Name: XXXXX

(where xxxxx was the name of the missing / unavailable object)

Regards
Jonathan Lewis

On Thu, 11 Jul 2024 at 13:01, Mikhail Velikikh <mvelikikh_at_gmail.com> wrote:

> If you want to pinpoint the exact object(s) causing ORA-942, then you can
> use the errorstack event as Mladen mentioned.
> Level 2 would be enough to dump the necessary library cache structures:
> alter session set events '942 errorstack(2)';
>
>
>>

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