Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HOW TO ACCELERATE THE FUNCTION APEX_MAIL.SEND ?

602857Nov 26 2008 — edited Feb 27 2009
HELLO EVERYBODY!

I DID AN APPLICATION WHICH HAS A TRIGGER ON INSERT IN A TABLE.
THIS TRIGGER SENDS AN EMAIL AND IT TAKES A LONG TIME FOR ARRAVING, IT IS ABOUT 6 MINUTES.
IT IS VERY SLOW, BECAUSE I HAVE TRIED WITH ANOTHER WAY USING THE UTL_SMTP.CONNECTION AND ITS PERFORMANCE GOOD.
I USED THE APEX FUNCTION LIKE THIS
APEX_MAIL.SEND(
p_to =>'ERIK@DOM.COM',
p_from =>'ERIK@DOM.COM',
p_body =>' MESSAGE:'||:NEW.NOMBRE,
p_body_html =>'<br> CLIENTE: '||V_NOMBRE_CLIENTE||', MAIL: '||V_EMAIL_CLIENTE||' <br>'
||V_MENSAJE
||' <br><br> DESCRIPCION: '||:NEW.COMENTARIOS||' <br>',
p_subj =>'REQ ',
p_cc =>'ERIK@DOM.COM'
);

WHAT DO I MUST DO FOR SOLVING THIS PROBLEM?
IS IT POSIBLE MAKE TUNNING TO THE APEX_MAIL.SEND?


ANY HELP WILL BE VERY APPRECIATED
THANK U IN ADVANCE.
BEST REGARDS
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2009
Added on Nov 26 2008
6 comments
1,565 views