Re: Missing Grant on Package Body

The "Name" is restricted to the name of the table and doesn't include the schema, and I think tc_table is your schema. I should have said I was using 19.11; and my choice on egrep was

egrep -nT -A+1 "about to signal" or19_ora_23101_level1.trc 5154 :about to signal 942
5155 -Name: FAIL1

It would be necessary to search the rest of the file for the object name to find the SQL, and that might be messy given the way the text would be arbitrarily cut into 16 byte pieces.

Regards
Jonathan Lewis

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

> 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