[Oracle-l] RE: Ora-4063 error

On Wed, Aug 11, 2010 at 1:40 PM, Goulet, Richard wrote:

Well, something new I learned today. Thanks Joe.


*Dick Goulet***
Senior Oracle DBA/NA Team Lead
PAREXEL International


------------------------------
*From:* oracle-l-bounce_at_freelists.org [mailto:
[email protected]] *On Behalf Of *Niall Litchfield
*Sent:* Wednesday, August 11, 2010 2:50 AM
*To:* Goulet, Richard
*Cc:* joe_dba_at_hotmail.com; [email protected]
*Subject:* Re: RE: Ora-4063 error

Or just show errors package body user.package

On 10 Aug 2010 23:50, "Goulet, Richard"
wrote:

No, the error is in plain view. It won't compile. Try alter package
user.air_life_usage compile body. then show errors.


*Dick Goulet***
Senior Oracle DBA/NA Team Lead
PAREXEL International


------------------------------
*From:* oracle-l-bounce_at_freelists.org [mailto:
[email protected]] *On Behalf Of *Joe Smith
*Sent:* Tuesday, August 10, 2010 6:08 PM
*To:* [email protected]
*Subject:* Ora-4063 error

How can I debug and/or trace this error:


Cannot execute SQL statement. ORA-04063: package body �...