Re: ACL Lists and UTL_MAIL FAIL when executed from a stored procedure.
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 12 Mar 2013 15:06:06 -0400
Message-ID: <CAGurbTPvXpRv8qkPu5rrsw8Xidu8qqpH=OC=aPH7sgs8BOwLVg_at_mail.gmail.com>
I ran your exact code sans the changes for smtp domain and from/to address in my environment. I did get following error, ORA-24247: network access denied by access control list (ACL)
Date: Tue, 12 Mar 2013 15:06:06 -0400
Message-ID: <CAGurbTPvXpRv8qkPu5rrsw8Xidu8qqpH=OC=aPH7sgs8BOwLVg_at_mail.gmail.com>
I ran your exact code sans the changes for smtp domain and from/to address in my environment. I did get following error, ORA-24247: network access denied by access control list (ACL)
Which I fixed by running DBMS_NETWORK_ACL_ADMIN.add_privilege for my id. Then just a call to stored procedure sent a nice email to mailbox.
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 12 2013 - 20:06:06 CET