Results 1 to 4 of 4

Thread: PL/SQL error..

  1. #1
    Join Date
    Oct 2008
    Posts
    7

    Unanswered: PL/SQL error..

    Hi all,

    While calling a function from another main function, I m getting this error..

    ORA-04068: existing state of packages has been discarded
    ORA-04064: not executed, invalidated function "IS_SAP.FN_DYNAMICREPORT_PRIVATE"
    ORA-06508: PL/SQL: could not find program unit being called
    ORA-06512: at "IS_SAP.SPR_DYNAMICREPORT_PARAM_IS1", line 4752
    ORA-06512: at line 2

    --------------------------
    SPR_DYNAMICREPORT_PARAM_IS1 is the calling procedure

    FN_DYNAMICREPORT_PRIVATE is the called procedure..

    Both the procedures are valid and compliling..

    When I try to execute the Sub Procedure Alone, its working fine..

    Need some suggestion on this..


    Thanks...

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Did you check a reason that lead to
    could not find program unit being called
    error?

  3. #3
    Join Date
    Oct 2008
    Posts
    7
    Thanks for the reply..

    I was able to comple the calling & called stored procedures successfully..

    When I run the called SP independently, I m getting proper output without errors.. Both SP s are in same instance..

    Wat else could have been the problem...?

  4. #4
    Join Date
    Feb 2005
    Posts
    57
    If the calling sp does something like drop/create table that is used in the called sp then I believe this can cause the called sp to become invalid.

Posting Permissions

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