FAQ
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
On Behalf Of Joe Smith
Sent: Tuesday, August 10, 2010 6:08 PM
To: oracle-l@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?

Search Discussions

  • Niall Litchfield at Aug 11, 2010 at 6:49 am
    Or just show errors package body user.package

    On 10 Aug 2010 23:50, "Goulet, Richard" 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_at_freelists.org
    *On Behalf Of *Joe Smith
    *Sent:* Tuesday, August 10, 2010 6:08 PM
    *To:* oracle-l@freelists.org
    *Subject:* Ora-4063 error

    How can I debug and/or trace this error:

    Cannot execute SQL statement. ORA-04063: package body “...
  • Niall Litchfield at Aug 11, 2010 at 3:32 pm
    your packages probably have far fewer errors than mine :(
    On Wed, Aug 11, 2010 at 1:40 PM, Goulet, Richard wrote:

    Well, something new I learned today. Thanks Joe.


    *Dick Goulet***
    Senior Oracle DBA/NA Team Lead
    PAREXEL International


    ------------------------------
    *From:* oracle-l-bounce_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Niall Litchfield
    *Sent:* Wednesday, August 11, 2010 2:50 AM
    *To:* Goulet, Richard
    *Cc:* joe_dba_at_hotmail.com; oracle-l@freelists.org
    *Subject:* Re: RE: Ora-4063 error

    Or just show errors package body user.package

    On 10 Aug 2010 23:50, "Goulet, Richard"
    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_at_freelists.org [mailto:
    oracle-l-bounce@freelists.org] *On Behalf Of *Joe Smith
    *Sent:* Tuesday, August 10, 2010 6:08 PM
    *To:* oracle-l@freelists.org
    *Subject:* Ora-4063 error

    How can I debug and/or trace this error:


    Cannot execute SQL statement. ORA-04063: package body �...
    --
    Niall Litchfield
    Oracle DBA
    http://www.orawin.info

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedAug 10, '10 at 10:49p
activeAug 11, '10 at 3:32p
posts3
users2
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase