Re: RE: Ora-4063 error
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Wed, 11 Aug 2010 16:32:55 +0100
your packages probably have far fewer errors than mine :(
On Wed, Aug 11, 2010 at 1:40 PM, Goulet, Richard <Richard.Goulet@xxxxxxxxxxx
> wrote:
> Well, something new I learned today. Thanks Joe.
>
>
> *Dick Goulet***
> Senior Oracle DBA/NA Team Lead
> PAREXEL International
>
>
> ------------------------------
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Niall Litchfield
> *Sent:* Wednesday, August 11, 2010 2:50 AM
> *To:* Goulet, Richard
> *Cc:* joe_dba@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: RE: Ora-4063 error
>
> Or just show errors package body user.package
>
> On 10 Aug 2010 23:50, "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Joe Smith
> *Sent:* Tuesday, August 10, 2010 6:08 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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
Other related posts:
