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?