Search notes:

PLS-00201: identifier … must be declared

connect / as sysdba

drop   user usr_1 cascade;
drop   user usr_2 cascade;
drop   role rol_x;

create user usr_1 identified by pw;
create user usr_2 identified by pw;

grant
   create session,
   create role,
   create procedure
to
   usr_1;

grant
   create session,
   create procedure
to
   usr_2;

connect usr_1/pw

create function func return number
   authid definer
is begin
   return 42;
end func;
/

create role rol_x;

grant execute on func to rol_x;
grant  rol_x to usr_2;

connect usr_2/pw

begin
   dbms_output.put_line('func = ' || usr_1.func); 
end;
/

create procedure proc
   authid definer
is begin
   dbms_output.put_line('func = ' || usr_1.func); 
end proc;
/

show errors
--
-- Errors for PROCEDURE PROC:
-- 
-- LINE/COL ERROR
-- -------- -----------------------------------------------------------------
-- 4/4      PL/SQL: Statement ignored
-- 4/38     PLS-00201: identifier 'USR_1.FUNC' must be declared


connect usr_1/pw

grant execute on func to usr_2;

connect usr_2/pw

begin
   proc;
end;
/

See also

PLS-00904: insufficient privilege to access object …
Oracle PL/SQL: Errors and warnings

Index

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...', 1745011789, '3.145.109.53', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/PL-SQL/errors-warnings/PLS-00201_identifier_must-be-declared/index(107): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78