4 Replies Latest reply: Jul 15, 2013 12:03 PM by tread RSS

    need to send mail using apex

    Chandra Bhanu

      Hi,

       

       

      I am using apex 4.2 and oracle 11g XE. I need to send mail so I used the following code:

       

       

      HTMLDB_MAIL.SEND(

            P_TO       =>  'xyz@cg.com',

            P_FROM     =>   abc@cg.com

            P_SUBJ     =>  'Data in TECHNICAL_DETAIL edited' ,

            P_BODY     =>  'Please click link below for affirmation/rejection of changes' ,

            P_BODY_HTML=>   '<p><a href="http://localhost:8080/apex/f?p=109:25:12079147455079">link</a></p>'

           );

       

       

      It is going t apex_mail_queue successfully. Then I used the following code:

      which one i should use:

      1.

           wwv_flow_mail.push_queue(

              P_SMTP_HOSTNAME => xxx

              P_SMTP_PORTNO => 'yyy

           );

       

       

      or

       

       

      2.

           APEX_MAIL.PUSH_QUEUE(

              P_SMTP_HOSTNAME => xxx

              P_SMTP_PORTNO => yyy

           );

       

       

      Also what else I need to send mail and what should i  ask DBA to provide me so that mail can be sent successfully.

      Please give some idea.

       

       

      Thanks,

      Chandra Bhanu