DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

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

  1. #1
    Join Date
    Apr 2004
    Location
    Boston MA
    Posts
    90

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

    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.


    Has anyone have encountered this message?
    How come Oracle can't find a program unit being called at runtime?
    Everything compiles so the absence of the program unit should have been caught at compile time. Why is this rased at runtime?
    How the programs may not be compatible?

    Yes, execute was granted to public.

    Need code?
    Last edited by ddrozdov; 04-23-2004 at 04:47 PM.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Need calling code and called code, i think.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2004
    Location
    Boston MA
    Posts
    90

    called code attached

    Here's calling code (test)

    this.optpages := avetestproc.ave_pgacct.get_optpages('6');

    It is called from a procedure that also sets the value of ct_global.cts$protocol to the appropriate schema name, thus the need for dynamic sql in the package.

    The package executes dynamic sql query once (at initialization) and then returnes results cached in an array. The idea is that when the function is called for the first time for this session, the array will be populated. The first call will take a little time. Subsequent calls to get_optpages should result in a very fast responce.
    Like I said, both the package and the calling procedure compile without errors. Dbms_sql is used because my db version is 8.1.7.0.0 and the NDS is not available.
    Attached Files Attached Files
    Last edited by ddrozdov; 04-24-2004 at 06:35 PM.

  4. #4
    Join Date
    Apr 2004
    Location
    Boston MA
    Posts
    90

    Even this doesn't run

    There's nothing more to strip down. I give up.
    I need help.


    CREATE OR REPLACE PACKAGE AVE_PGACCT IS
    FUNCTION get_optpages(i_blk VARCHAR2)
    RETURN VARCHAR2;

    END AVE_PGACCT;
    /

    CREATE OR REPLACE PACKAGE BODY AVE_PGACCT AS

    FUNCTION get_optpages(i_blk VARCHAR2)
    RETURN VARCHAR2
    IS
    BEGIN
    return i_blk;
    END get_optpages;


    END AVE_PGACCT;
    /

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