This discussion is archived
4 Replies Latest reply: Jul 15, 2013 10:03 AM by tread RSS

need to send mail using apex

ChandraBhanu Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points