[b]اكود الموجود في المنتدي لم يتم ارسالة رسالة الي الايميل بعد عملية setup بالنسبة smtp ارجو المساعدة[/b]

sending mail from oracle db note
********************************

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='domain.com' SCOPE=SPFILE;

SHUTDOWN IMMEDIATE

STARTUP


note: if you got an error in this step cuz u dont have SPFILE you can create it 


SQL> create spfile from pfile; File created.

shutsdown immediate and startup

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/10.2.0
                                                /db_1/dbs/spfilectmsuat.ora



With the configuration complete we can now send a mail using:

BEGIN UTL_MAIL.send(sender     => 'me@domain.com',

               recipients => 'person1@domain.com,person2@domain.com',

               cc         => 'person3@domain.com',

               bcc        => 'myboss@domain.com',

               subject    => 'UTL_MAIL Test',

               message    => 'If you get this message it worked!');

END;

/

for example 
*************
BEGIN UTL_MAIL.send(sender     => 'HOSSAM@hossam.com.eg',

               recipients => 'me@domain.com',

               cc         => 'me@domain.com',

               bcc        => 'me@domain.com',

               subject    => 'UTL_MAIL Test',

               message    => 'If you get this message it worked!');

END;

/

********************************************************************************
**************************
hossam

How to add attchment ?