Re: Missing Grant on Package Body

I guess I should have mentioned its an Oracle shrink-wrapped application.  I have opened an SR but the analyst is asking me Why I want to recompile an INVALID package body.  I would have thought that was evident but I played along.  Seems Oracle has something he called OOB to do SchemaValidation.

• Alan

On 7/10/2024 10:11 PM, Andy Sayer wrote:
> 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