ORA-04042: procedure 12c PDB
Gurus, My application uses UTL_MAIL and i installed it the utlmail.sql and prvtmail.pb on root container but i can see or grant execute on this package from PDB getting the below error. CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 PF01PDB READ WRITE NO SQL> ALTER SESSION SET CONTAINER=PF01PDB; Session altered. SQL> grant execute on sys.utl_mail to prxw01; grant execute on sys.utl_mail to grediag * ERROR at line 1: ORA-04042: procedure, function, package, or package body does not exist Thanks in advance