![]() NOTE – Please check with your OS admin for this smtp mail server hostname/hostname. ![]() SQL> GRANT EXECUTE ON utl_smtp TO PUBLIC ![]() SQL> GRANT EXECUTE ON utl_mail TO PUBLIC select object_name,object_type,owner from dba_objects where object_name in('UTL_MAIL','UTL_SMTP') Īs in our case, both utl_mail and utl_stmp are not installed. Verify whether UTL_MAIL and UTL_SMTP is installed or not. If XDB component is not installed Check – How to install XDB component in oracle. For this make sure XDB component is installed. ![]() From oracle 11gR2 onwards ACLs(Access control list) are mandatory to send mail from procedure using UTL_MAIL or UTL_SMTP.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |