Search notes:

ORA-04067: … not executed, … does not exist

Create a package without package body:

create or replace package tq84_ora_04067_pkg
   authid definer
as
   function f return number;
end tq84_ora_04067_pkg;
/

Create a view that uses the function in the package. The view compiles because the function tq84_ora_04067_view.f is declared even though the package body does not exist:

create or replace view tq84_ora_04067_view as
select
   tq84_ora_04067_pkg.f
from
   dual;

However, when the view is used, it will report the missing package body:

select * from tq84_ora_04067_view;
-- ORA-04067: not executed, package body "RENE.TQ84_ORA_0406._PKG" does not exist
-- ORA-06508: PL/SQL: could not find program unit being called: "RENE.TQ84_ORA_04067_PKG"
-- ORA-06512: at line 1

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1761458785, '216.73.216.115', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/errors/ORA-04067_not-executed_does-not-exist(58): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78

ORA-04067: … not executed, … does not exist

See also