Re: Missing Grant on Package Body

Hi Alan,

There are ways to unwrap a wrapped pl/sql package without much effort.

That said, if it’s wrapped then presumably it’s from a third party? In which case I would go straight to them and ask for support (assuming you’ve followed the installation instructions). Trying to fix it yourself is brave but you may end up with an unexpected and unsupported setup.

Thanks,
Andy

On Wed, 10 Jul 2024 at 6:31 PM, Alan Sterger <asterger_at_earthlink.net> 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
>
>
>

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