Re: Package

From: <prochak_at_my-dejanews.com>
Date: Tue, 10 Nov 1998 15:43:24 GMT
Message-ID: <729mus$j6r$1@nnrp1.dejanews.com>

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 Received on Tue Nov 10 1998 - 09:43:24 CST