3 Replies Latest reply: Apr 10, 2011 6:19 AM by jonjac RSS

    how to set smtp_out_server parameter?

    KPR
      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