Re: Missing Grant on Package Body
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Thu, 11 Jul 2024 07:36:21 -0400
Message-ID: <05a60f05-1f06-4460-b790-29b1e7649ace_at_gmail.com>
Date: Thu, 11 Jul 2024 07:36:21 -0400
Message-ID: <05a60f05-1f06-4460-b790-29b1e7649ace_at_gmail.com>
On 7/10/24 9:30 PM, Alan Sterger wrote:
Hey List,
Have a package body that does not compile:
Errors for ...
LINE/COL ERROR
-------- -----------------------------------------------------------------
10725/21 PL/SQL: SQL Statement ignored
10726/26 PL/SQL: ORA-00942: table or view does not exist
Oh, and the package body is wrapped therefore, can't peek into the DDL. Is there a way to determine what/where the missing table or view is?
-- Alan
--
http://www.freelists.org/webpage/oracle-l
Oh, but you can peek into DDL:
https://github.com/Trivadis/plsql-unwrapper-sqldev/releases
Also, try this: ALTER SESSION SET EVENTS='942 trace name
errorstack forever, level 12';
After that, every reference of a non-existing table will produce
a trace file, visible in the alert.log. You will see which tables
are missing or are not granted from the trace.