No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 1100
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48742
Total active users1337
Act. users last 24h1
Act. users last hour0
Registered user hits last week108
Registered user hits last month471
Go up

not able to send mail via pl/sql code
Next thread: Shell Script not working
Prev thread: Performance Issue

Message Score Author Date
Hi Team, development team is not able to send m...... Mohit Jain Oct 10, 2012, 14:08
11g introduced the ACL (Access Control List) for T...... Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts Michel Cadot Oct 10, 2012, 14:15
Hi Mohit,  "<i>any pointer would be helpful</i>...... Bruno Vroman Oct 10, 2012, 15:01
Thanks Micheal it worked... Mohit Jain Oct 11, 2012, 06:25
Hi Mohit, amazing: the <i>same</i> answer on 17...... Bruno Vroman Oct 11, 2012, 08:10
The technology was not mature at this time. :o) ...... Michel Cadot Oct 11, 2012, 08:48

Follow up by mail Click here

Subject: not able to send mail via pl/sql code
Author: Mohit Jain, India
Date: Oct 10, 2012, 14:08, 3888 days ago
Os info: Linux Red Hat
Oracle info: 11.1.0.7
Message: Hi Team,

development team is not able to send mail via pl/sql code, they are getting the below errot

ORA-24247: network access denied by access control list (ACL)
ORA-06512: at "PFCLAS.SEND_MAIL", line 50
ORA-06512: at line 2

any pointers would be helpful.

Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: not able to send mail via pl/sql code
Author: Michel Cadot, France
Date: Oct 10, 2012, 14:15, 3888 days ago
Score:   Score: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 PtsScore: 300 Pts
Message: 11g introduced the ACL (Access Control List) for TCP accesses.
You must grant these accesses to your account (in addition to have granted it the privilege to execute the procedure): 

 begin

  dbms_network_acl_admin.create_acl (

    acl         => 'utl_mail.xml',

    description => 'Allow mail to be sent',

    principal   => 'MICHEL',

    is_grant    => TRUE,

    privilege   => 'connect'

    );

  dbms_network_acl_admin.add_privilege (

    acl       => 'utl_mail.xml',

    principal => 'MICHEL',

    is_grant  => TRUE,

    privilege => 'resolve'

  );

  dbms_network_acl_admin.assign_acl (

    acl  => 'utl_mail.xml',

    host => '<your smtp server host name or address>'

  );

  commit;

end;

/

Replace MICHEL by your account.

Regards
Michel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: not able to send mail via pl/sql code
Author: Bruno Vroman, Belgium
Date: Oct 10, 2012, 15:01, 3888 days ago
Message: Hi Mohit,

 "any pointer would be helpful"? I'm not sure ;-)

Here is a pointer:
  http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=55300#174970

you will see that you asked the same question some weeks ago. If the "set up ACL" did not work mid September, why would it work today...

But try again and search for documentation, ACL is your issue here, as clearly stated by your error message.

Best regards,

Bruno Vroman.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: not able to send mail via pl/sql code
Author: Mohit Jain, India
Date: Oct 11, 2012, 06:25, 3887 days ago
Message: Thanks Micheal
it worked
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: not able to send mail via pl/sql code
Author: Bruno Vroman, Belgium
Date: Oct 11, 2012, 08:10, 3887 days ago
Message: Hi Mohit,

amazing: the same answer on 17-SEP (with some more explanations: http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=55300#174970 ) received the reply "Bruno, this did not helped."

Well, ... ;-)

Bruno.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here
Subject: Re: not able to send mail via pl/sql code
Author: Michel Cadot, France
Date: Oct 11, 2012, 08:48, 3887 days ago
Message:
The technology was not mature at this time. :o)

Regards
Michel


Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here