Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to set smtp_out_server parameter?

KPRApr 10 2011 — edited Apr 10 2011
Hi

I am praticing on utl_mail package for send an emai to my personal email id. I understood some contents for the same. I am using oracle Enterprize 10.2.0 version. I have given comment lines which I have not understood.
understood contents
*****************
CONN sys/password AS SYSDBA
@$ORACLE_HOME/rdbms/admin/utlmail.sql
@$ORACLE_HOME/rdbms/admin/prvtmail.plb
In addition the SMTP_OUT_SERVER parameter must be set to identify the SMTP server:
CONN sys/password AS SYSDBA
ALTER SYSTEM SET smtp_out_server='smtp.domain.com' SCOPE=SPFILE;  ----- here I have small doubt. 'smtp.domain.com' --- instead of this word what I have to replace? or  is this  correct? 
SHUTDOWN IMMEDIATE
STARTUP
With the configuration complete we can now send a mail using:
BEGIN
  UTL_MAIL.send(sender     => 'me@domain.com',  --- Can I give my yahoo id here ?
                recipients => 'person1@domain.com,person2@domain.com',  --- can I give my another email id here ?
                cc         => 'person3@domain.com',
                bcc        => 'myboss@domain.com',
                subject    => 'UTL_MAIL Test',
                message    => 'If you get this message it worked!');
END;
Please expline me...!!

Regards
KPR

Edited by: KPR on Apr 10, 2011 1:17 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 8 2011
Added on Apr 10 2011
3 comments
9,418 views