Emd_notification package body goes invalid.
Based on the EM recommendation, I revoked execute on utl_file, utl_smtp, utl_tcp, utl_http and dbms_random from public.
After the revoke, i realised that the package body for emd_notifcation goes invalid. I tried compiling and it says 'emd_notification body compiled' but when i check for invalid objects, it still shows that package body of emd_notification is invalid.
Does the invalidation got any thing to do with the execute privileges that I revoke? How should i resolve the problem?
Thanks.