ora-04068,Ora-04063
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-04068,Ora-04063

Hybrid View

  1. #1
    Join Date
    May 2004
    Posts
    2

    ora-04068,Ora-04063

    Hi,

    We have upgraded the oracle to 9.2.0.4.
    There are some daily jobs. For first few days after the upgardation it was working fine but on one day we are facing below error...
    ERROR at line 1:
    ORA-04068: existing state of packages has been discarded
    ORA-04063: package body "TMOADMIN.EDIT_SPT_EVNT_RULE" has errors
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at line 161
    We recompile the libraries and it was working fine.
    can any body let me know why this error occure and what could we do so that this error should not come in future.

    Thanks & regards,

  2. #2
    Join Date
    Apr 2004
    Location
    Boston MA
    Posts
    90
    Say you have an active session that is using package x
    the package x is instantiated in the SGA and in PGA for this session.

    Say another session runs create or replace on x

    Next time the active session is calling anythying from x it gets this exception.
    ORA-04068: existing state of packages has been discarded

    Oracle says: something changed in this package, Maybe the global variable whose value you are storing in pga does not exist anymore.

    Did you also bounce the DB when you recompiled the package?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width