No question at this time
DBA Top 10
1 M. Cadot 9500
2 B. Vroman 7200
3 A. Kavsek 4600
4 P. Wisse 2000
5 J. PĂ©ran 1700
6 J. Schnackenberg 1200
7 T. Boles 800
8 D. Johnson 600
9 D. Dave 400
10 S. Spb 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48624
Total active users1393
Act. users last 24h1
Act. users last hour0
Registered user hits last week48
Registered user hits last month117
Go up

UTL_SMTP
Next thread: Select query taking time -, in 24 hours window, the query having issue in between 21:30 to 22:30.
Prev thread: Query Help!

Message Score Author Date
Dears, I am using utl_smtp package to send emai...... sandesh deshmukh Jul 01, 2021, 11:54
I'm not sure how you do this, but I had this probl...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts David Johnson Jul 01, 2021, 15:55
>>> <i> procedure,Procedure is geeting executed ...... Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts Michel Cadot Jul 01, 2021, 17:04

Follow up by mail Click here


Subject: UTL_SMTP
Author: sandesh deshmukh, India
Date: Jul 01, 2021, 11:54, 34 days ago
Os info: Windows
Oracle info: 11g
Message: Dears,

I am using utl_smtp package to send email in pl/sql procedure,Procedure is geeting executed successfully but mail does not get send,but when i execute same code within pl/sql block its working.Can anybody guide here,what can be the issue.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: UTL_SMTP
Author: David Johnson, United States
Date: Jul 01, 2021, 15:55, 34 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: I'm not sure how you do this, but I had this problem,
the dba told me he had to setup the ACL table to allow
the user sending mail.

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

Subject: Re: UTL_SMTP
Author: Michel Cadot, France
Date: Jul 01, 2021, 17:04, 34 days ago
Score:   Score: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 PtsScore: 600 Pts
Message:
>>> procedure,Procedure is geeting executed successfully but mail does not get send

I bet your procedure contains a "WHEN OTHERS" clause.
Read http://www.orafaq.com/wiki/WHEN_OTHERS


For ACLs, read the following thread:
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=55904#175938

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