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? :confused:

Need calling code and called code, i think.

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.
:confused:

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


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;
/