Re: RE: Ora-4063 error

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 11 Aug 2010 16:32:55 +0100
Message-ID: <AANLkTikAhB71eoUS0GyBeNjbN0DXzuYeaqYjNWqBT156_at_mail.gmail.com>

your packages probably have far fewer errors than mine :(

On Wed, Aug 11, 2010 at 1:40 PM, Goulet, Richard <Richard.Goulet_at_parexel.com
> 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:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Niall Litchfield
> *Sent:* Wednesday, August 11, 2010 2:50 AM
> *To:* Goulet, Richard
> *Cc:* joe_dba_at_hotmail.com; oracle-l_at_freelists.org
> *Subject:* Re: RE: Ora-4063 error
>
> Or just show errors package body user.package
>
> On 10 Aug 2010 23:50, "Goulet, Richard" <Richard.Goulet_at_parexel.com>
> 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:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *Joe Smith
> *Sent:* Tuesday, August 10, 2010 6:08 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Ora-4063 error
>
> How can I debug and/or trace this error:
>
>
> Cannot execute SQL statement. ORA-04063: package body “...
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Wed Aug 11 2010 - 10:32:55 CDT