No question at this time
DBA Top 10
1 M. Cadot 10900
2 B. Vroman 6700
3 A. Kavsek 5100
4 J. Schnackenberg 3200
5 P. Wisse 3100
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48581
Total active users1393
Act. users last 24h5
Act. users last hour0
Registered user hits last week165
Registered user hits last month388
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, 3064 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, 3064 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, 3064 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, 3063 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, 3063 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, 3063 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