RE: RE: Ora-4063 error

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: <niall.litchfield@xxxxxxxxx>
  • Date: Wed, 11 Aug 2010 08:40:21 -0400

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

Other related posts: