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