title: creating a oracle trigger for sending mail after insert data in the table
body: <p>i am creating a oracle trigger for sending mail after insert or update data in database table
  but there is a error occured </p>
  
  <pre><code>`ORA-24247: network access denied by access control list (ACL)
  `ORA-06512: at "SYS.UTL_TCP", line 17`
  `ORA-06512: at "SYS.UTL_TCP", line 246`
  `ORA-06512: at "SYS.UTL_SMTP", line 127`
  `ORA-06512: at "SYS.UTL_SMTP", line 150`
  `ORA-06512: at "TEST.SCRIPT_MAIL", line 9`
  `ORA-04088: error during execution of trigger 'TEST.SCRIPT_MAIL'
  </code></pre>
  
  <p>i am using this code</p>
  
  <pre><code>`CREATE OR REPLACE TRIGGER TEST.SCRIPT_MAIL 
  AFTER INSERT 
  ON TEST.PARTY_EMAIL 
  REFERENCING NEW AS NEW OLD AS OLD 
  FOR EACH ROW
  DECLARE
    v_From      VARCHAR2(80) := 'from@abc.in';
    v_Recipient VARCHAR2(80) := 'to@abcd.in';
    v_Subject   VARCHAR2(80) := 'test subject';
    v_Mail_Host VARCHAR2(30) := '&lt;my domain&gt;';
    v_Mail_Conn utl_smtp.Connection;
    crlf        VARCHAR2(2)  := chr(13)||chr(10);
  BEGIN
   v_Mail_Conn := utl_smtp.Open_Connection(v_Mail_Host, 587);
   utl_smtp.Helo(v_Mail_Conn, v_Mail_Host);
   utl_smtp.Mail(v_Mail_Conn, v_From);
   utl_smtp.Rcpt(v_Mail_Conn, v_Recipient);
   utl_smtp.Data(v_Mail_Conn,
     'Date: '   || to_char(sysdate, 'Dy, DD Mon YYYY hh24:mi:ss') || crlf ||
     'From: '   || v_From || crlf ||
     'Subject: '|| v_Subject || crlf ||
     'To: '     || v_Recipient || crlf ||
     crlf ||
     'some message text'|| crlf ||    -- Message body
     'more message text'|| crlf
   );
  utl_smtp.Quit(v_mail_conn);
  EXCEPTION`
   WHEN utl_smtp.Transient_Error OR utl_smtp.Permanent_Error then
     raise_application_error(-20000, 'Unable to send mail', TRUE);
  END;`
  </code></pre>
  
  <p>how to solve it 
  please help</p>