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