title: APEX_MAIL.SEND function not working though its not giving any error
body: <p>Have to send email from <strong><code>oracle apex</code></strong> using <code>APEX_MAIL.SEND()</code> method. </p>
  
  <p>I am using the code:</p>
  
  <pre><code>BEGIN
  
   apex_mail.send(p_to   =&gt; 'tanmoydawn@gmail.com'/*l_to_addr*/,        
                   p_from =&gt; 'tanmoydawn@gmail.com'/*l_from_addr*/,
                   p_bcc  =&gt; l_bcc_addr,
                   p_subj =&gt; l_mail_sub,
                   p_body =&gt; 'Service Request ' || :mail_body ||
  'Note:- This is a system generated Email. Please DO NOT REPLY to it.');
  
  apex_mail.push_queue;  
  
  EXCEPTION
  
    when others then    
         INSERT INTO send_mail_error_test VALUES ('Send_mail',systimestamp,:service_request_id||'-err:'||seq_service_req_error_id.NEXTVAL);  
  
  COMMIT;  
  
  END;
  </code></pre>
  
  <p>*** all the variables contain correct values</p>
  
  <ol>
  <li><p>Working with a database and that database has ACL(access control list) access</p></li>
  <li><p>In apex administrative services, Configured instance settings for email as hostname, port , email provisioning enabled.</p></li>
  <li><p>UTL_SMTP package is installed</p></li>
  <li><p>From the same process, at the same point of control flow a code to send mail using utl_Smtp is working fine, though that apex_mail.send() is not working.</p></li>
  <li><p>That <code>apex_mail.send()</code> is not giving any error or exception, but i am not recieving email from it. </p></li>
  <li><p>Have one confusion, got some solutions like that, <em>'<code>APEX_040200</code>' should have been added to <code>ACL</code></em>. But the database I am using and implementing the code on it, say '<code>apex_user</code>' is already added to <code>ACL</code>. Even now do I have to add '<code>APEX_040200</code>' or '<code>APEX_050200</code>' to <code>ACL</code>?  </p></li>
  </ol>
  
  <p>can anyone help me out and give me a fruitful solution? I am using apex 5.0.2.00.07. </p>