ORA-06508: PL/SQL: could not find program unit being called
PL/SQL called a procedure or package that is missing, invalid or not accessible at run time, often after it was dropped or failed to recompile.
- Error code
ORA-06508- Category
- PL/SQL
What it means
ORA-06508 means a called program unit couldn't be found or loaded when the call ran. It frequently follows ORA-04068 (existing state of packages has been discarded) after a package was recompiled while sessions were using it.
Common causes
- The called package or procedure was dropped or is invalid after a change it depends on.
- The calling session had package state discarded by a recompilation.
- Missing privilege on the called unit.
How to fix it
-
Find invalid objects and recompile them.
SELECT object_name, object_type FROM user_objects WHERE status = 'INVALID'; ALTER PACKAGE billing_pkg COMPILE BODY;
-
Reconnect sessions that held old package state, or retry the call once.
Related errors
ORA-04068existing state of packages has been discardedORA-06550PL/SQL compilation error at line, columnORA-04021timeout waiting to lock object
More pl/sql errors
ORA-01403no data foundORA-01422exact fetch returns more than requested rowsORA-06502PL/SQL: numeric or value errorORA-06512at line (PL/SQL error stack)ORA-06503PL/SQL: function returned without valueORA-04091table is mutating, trigger may not see itORA-04088error during execution of trigger
The code and message text are from the Oracle Database Error Help. Browse the full Oracle error list or search every database error.
Work on Oracle in SQLly
A native SQL client for macOS, Windows and Linux with schema-aware IntelliSense, guardrails for risky statements and clear error messages, for Oracle and the other databases you use.