Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2008
    Posts
    14

    Question Unanswered: ORA-06508: PL/SQL: could not find program unit being called

    Hi,

    Iam getting an error as given below when a procedure/function is called.

    The FUNCTIONNAME1 calls FUNCTIONNAME2 from within.

    SQL> select FUNCTIONNAME1(10) from dual;
    select FUNCTIONNAME1(10) from dual
    *
    ERROR at line 1:
    ORA-04068: existing state of packages has been discarded
    ORA-04065: not executed, altered or dropped stored procedure "FUNCTIONNAME2"
    ORA-06508: PL/SQL: could not find program unit being called: "FUNCTIONNAME2"
    ORA-06512: at "FUNCTIONNAME1", line 7

    However, there are no invalid objects and both the functions are VALID.

    The issue seems to be intermittent and gets fixed without any steps being taken, which makes it difficult to resolve.

    The details of the database we are using is as given below

    Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    PL/SQL Release 11.2.0.1.0 - Production
    CORE 11.2.0.1.0 Production
    TNS for Linux: Version 11.2.0.1.0 - Production
    NLSRTL Version 11.2.0.1.0 - Production


    Could you kindly let me know what might be the issue.

    Many thanks in advance.

    Thanks and Regards
    Vipin

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Code:
    04065, 00000, "not executed, altered or dropped %s"
    // *Cause:  Attempt to execute a stored procedure that has
    //          been altered or dropped thus making it not callable from the
    //          calling procedure.
    // *Action: Recompile its dependents.
    >Could you kindly let me know what might be the issue.
    cease doing DDL against running DB
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2008
    Posts
    14
    Quote Originally Posted by anacedent View Post
    Code:
    04065, 00000, "not executed, altered or dropped %s"
    // *Cause:  Attempt to execute a stored procedure that has
    //          been altered or dropped thus making it not callable from the
    //          calling procedure.
    // *Action: Recompile its dependents.
    >Could you kindly let me know what might be the issue.
    cease doing DDL against running DB
    Hi,
    Thank you for the suggestion.
    However the procedure has not been altered or dropped.
    Moreover, the issue gets resolved automatically.

    Iam getting this error from the application (i.e through front end screen).
    Also if I call the second function which is given in the error, it works fine.

    SQL> select FUNCTIONNAME2(10) from dual;
    FUNCTIONNAME2(10)
    ---------------------------
    1




    Thanks and Regards

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >However the procedure has not been altered or dropped.
    I did NOT say DDL against function!
    DDL likely occurred against objects FUNCTION accesses.
    >Moreover, the issue gets resolved automatically.
    Yes, Oracle self heals when folks shoot themselves in the foot!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Mar 2008
    Posts
    14
    Quote Originally Posted by anacedent View Post
    >However the procedure has not been altered or dropped.
    I did NOT say DDL against function!
    DDL likely occurred against objects FUNCTION accesses.
    >Moreover, the issue gets resolved automatically.
    Yes, Oracle self heals when folks shoot themselves in the foot!
    Hi,

    Thank you.

    There is no DDL happening on the Objects the function is calling, as it just returns the market time. Also this is the first time we are experiencing this problem in our environment even though the function has been existing in the database for almost 5 years now.
    The reason we are concerned about is that the earlier Oracle version we had was on 'Solaris' and now we have moved to 'Linux'. So just wondering if this has anything to do with the error.

    We had contacted the DBA's for this but they also could not find any issues with the Function.

  6. #6
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >We had contacted the DBA's for this but they also could not find any issues with the Function.
    File a Service Request with MOS
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  7. #7
    Join Date
    Mar 2008
    Posts
    14
    Quote Originally Posted by anacedent View Post
    >We had contacted the DBA's for this but they also could not find any issues with the Function.
    File a Service Request with MOS
    Thanks. I have done that now.
    Wanted to know if someone was aware about this issue ( just in case)

Posting Permissions

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