Jump to content


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About shantanu_siddhartha

  • Rank
  1. shantanu_siddhartha

    UTL_SMTP error: ORA-24247

    Hi, Update on this. SMTP is working now. Change: added the AUTHID CURRENT_USER clause in package definition. Example: create or replace PACKAGE xxcg_cap_email_t_p1 AUTHID CURRENT_USER AS PROCEDURE main (pv_errbuff IN OUT VARCHAR2, pn_retcode IN OUT NUMBER); END xxcg_cap_email_t_p1; Thanks.
  2. shantanu_siddhartha

    UTL_SMTP error: ORA-24247

    hello, I have a package to send mails with attachments via UTL_SMTP. This package when executed from back end, triggers mails etc perfectly. But same thing when done via a package and concurrent program throws ORA-24247: network access denied by access control list (ACL). I'm using host as 'localhost'. On querying this: SELECT * FROM dba_network_acls; I get: On querying this: SELECT * FROM dba_network_acl_privileges; I get: Please advise. Thanks in advance. Regards, Shantanu