Re: Missing Grant on Package Body

there are no such lines in 19.23 for my sample test case using the default DB parameters.
alert log:
2024-07-11T12:46:05.314540+00:00
PDB(3):Errors in file
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc: ORA-00942: table or view does not exist

egrep -iw 'signal|tc_table'
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_58350.trc 7F6E37B25750 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T] 7F6E37FBEE40 4F524620 4354204D 4241545F 542E454C [ FROM TC_TABLE.T] Best regards,
*Mikhail Velikikh*

On Thu, 11 Jul 2024 at 13:44, Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> 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