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
*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
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-lReceived on Wed Aug 11 2010 - 01:49:53 CDT