Database Administration (MOSC)

MOSC Banner

EXECUTE on SYS.UTL_MAIL in a 12.2.0.1 PDB

edited Oct 9, 2018 3:43PM in Database Administration (MOSC) 4 commentsAnswered

Hi

I have a 12.2.0.1 CDB.  I have created sys.utl_mail package in the CDB signed on as SYS.  when I query DBA_OBJECTS with container as CDB$ROOT, I see the package, Package Body and Public Synonym listed.

Then I had plugged in a PDB ( this migrated from another CDB in the same server) and when I run the same select after setting container to the PDB, the SYS.UTL_MAIL does not show up.

When I try to grant execute on SYS.UTL_MAIL to a local user, that throws an error that the program does not exits.

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