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