RE: Ora-4063 error

From: Goulet, Richard <Richard.Goulet_at_parexel.com>
Date: Tue, 10 Aug 2010 18:49:10 -0400
Message-ID: <6B0D50B70F12BD41B5A67F14F5AA887F09207D44_at_us-bos-mx022.na.pxl.int>

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 "USER.AIR_LIFE_USAGE" has errors ORA-06508: PL/SQL: could not find program unit
Being called: "USER.AIR_LIFE_USAGE" ORA-06512: at line 1 'begin air_life_usage.update_hours (:1, :2); end;'  

Does this have to do with the shared pool?  

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

Received on Tue Aug 10 2010 - 17:49:10 CDT