Database Administration (MOSC)

MOSC Banner

ORA-04042: procedure 12c PDB

edited Mar 30, 2016 9:33PM in Database Administration (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center