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!

APEX email template is cached

InoLMar 12 2024

I'm developing an email using a template (in 23.2). Easy to do, but testing is a bit of a hassle.

The template is cached, and changes to the template are not picked up.
I use this code in TOAD to easily test the email:

DECLARE
 l_mail_id number;
BEGIN
 wwv_flow_api.set_security_group_id;
 l_mail_id := apex_mail.send (
       p_template_static_id => 'MY_TEMPLATE',
       p_application_id     => 500,
       p_placeholders       => '{ <my json> }',
       p_to                 => 'me@mycmpny.com',
       p_from               => 'noreply@mycmpny.com'
        
       );
 apex_mail.push_queue;      
END;

Every time I change the template and run this code, the old version is used. I have to log out of TOAD and log in again to get the new template.

Is there an easier way to force a reload of the template?

This post has been answered by AndyH on Mar 12 2024
Jump to Answer
Comments
Post Details
Added on Mar 12 2024
2 comments
519 views