Re: Package

What if the table owner is uatdba and the package is created by uatuser. Inside this package, it will called for the uatdba' tables.

Pls advise
Sok Peng

In article <729mus$j6r$1_at_nnrp1.dejanews.com>,   prochak_at_my-dejanews.com wrote:
> In article <72906m$dt$1_at_nnrp1.dejanews.com>,
> speng_at_ncs.com.sg wrote:
> > Is there a way to check the owner of the package created.
> >
> > I have encountered this error show below:
> >
> > oracle error code : 4068.
> > Oracle error msg : ORA-04068: existing state of packages has been discarded
> > ORA-04063: package body
> > "UATUSER.MAINSQL" has errors ORA-06508: PL/SQL: could not find program unit
> > being called ORA-06512: at line 1 .
> >
> > Pls help!
> > --
> > Sok Peng
>
> Looks like your package needs to be recompiled before you can execute
> it again. Maybe a table used by the package changed or something else.
> I don't think this has anything to do with the owner or priveleges.
> (but I can be wrong. It's happened before.)
>
> --
> Ed Prochak
> Magic Interface, Ltd.
> 440-498-3702
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

--
Sok Peng

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 10 1998 - 21:27:26 CST