This discussion is archived
0 Replies Latest reply: Feb 6, 2013 3:20 AM by 982623 RSS

SMTP service on in oracle database to send mail directly from oracle databa

982623 Newbie
Currently Being Moderated
I want to send mail from my oracle database.
I have followed the steps below:
1> Run utlmail.sql & prvtmail.plb

2>set smtp_out_server parameter

3>To send mail, execute utl_mail.send(sender=>'',recipients=>'',message=>'ABC');

My concept is to provide smtp/mail server ip & port in smtp_out_server parameter's value.

But One person said that oracle database server can make itself as a smtp server.So that we can assign database server ip & port in smtp_out_server parameter's value.We have to just on the smtp service in oracle database itself.There is no requirement of smtp/mail server ip & port.Is it true?How can we do that?

In google to Add an SMTP Service,the document said in the 1st line that on the Services tab on the left, select a Process tree node (for example, the default Oracle Enterprise Gateway).
I am sorry to say that I did not find that.Anyone can help me please?

Please reply anyone.

Edited by: 979620 on Feb 6, 2013 3:20 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points