Results 1 to 7 of 7

Thread: Ora-06508

  1. #1
    Join Date
    Mar 2004
    Posts
    22

    Question Unanswered: Ora-06508

    HI FRENZ
    I HAVE DOWNLOADED A UTILITY HAVING TWO PLL FILES AND SOME DLL FILES WHEN I CALL A PROCEDURE AFTER ATTACHING THE THE PLL FILES ITS GIVING ABOVE ERROR WITH DESCRIPTION "CAN NOT FIND CALLED PROCEDURE"

    PLZ HELP

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi Roma,

    Have look for the Error Description :

    ---------------------------------------------------------
    ORA-06508 PL/SQL: could not find program unit being called
    Cause: An attempt was made to call a stored program that could not be found.
    The program may have been dropped or incompatibly modified, or have
    compiled with errors.
    Action: Check that all referenced programs, including their package bodies,
    exist and are compatible.
    -------------------------------------------------------------

    Plz ensure that the Called Procedure existing in the Schema! or compiled with errors.

  3. #3
    Join Date
    Mar 2004
    Posts
    22
    how shud i check that
    i have all the pll and dll files in the same folders

  4. #4
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi Roma,

    I can't Catch ur Query cud u get in detail.

  5. #5
    Join Date
    Mar 2004
    Posts
    22
    you said
    ---------------------------------------------------------
    ORA-06508 PL/SQL: could not find program unit being called
    Cause: An attempt was made to call a stored program that could not be found.
    The program may have been dropped or incompatibly modified, or have
    compiled with errors.
    Action: Check that all referenced programs, including their package bodies,
    exist and are compatible.
    -------------------------------------------------------------

    Plz ensure that the Called Procedure existing in the Schema! or compiled with errors.


    thats wat i m asking how should i check that

  6. #6
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi,

    Have u created or complied those procedure in Oracle Database. If u do so.

    Then check with this query

    SELECT text FROM USER_SOURCE WHERE NAME='<your procedure name>';

    Result will displays the Procedure .

    If else it displays NO ROWS SELECTED

  7. #7
    Join Date
    Mar 2004
    Posts
    22
    i havent compiled them in database i just compiled them using devloper forms ide but cudnt get any plx files..........
    how to compile them in oracle database.

Posting Permissions

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