Re: RE: Ora-4063 error

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Wed, 11 Aug 2010 07:49:53 +0100
Message-ID: <AANLkTinPn+obpsh3UiscUab0idCQFo=XYK6uW0SAVPMN_at_mail.gmail.com>



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 “...

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Aug 11 2010 - 01:49:53 CDT

Original text of this message