RE: Ora-4063 error
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <joe_dba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 10 Aug 2010 18:49:10 -0400
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
"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?
Other related posts:
