24.5 PREPARE_TEMPLATE Procedure

Procedure to return a formatted mail based on an e-mail template where the placeholders specified as json string are substituted.

Syntax

PROCEDURE PREPARE_TEMPLATE (
  P_STATIC_ID       IN      VARCHAR2,
  P_PLACEHOLDERS    IN     CLOB,
   P_APPLICATION_ID  IN     NUMBER DEFAULT, 
   P_SUBJECT         OUT    VARCHAR2,
   P_HTML            OUT    CLOB,
   P_TEXT                OUT    CLOB );

Parameters

Example

declare
  l_subject varchar2( 4000 );
  l_html    clob;
  l_text    clob;
begin
  apex_mail.prepare_template (
  p_static_id    => 'ORDER',
  p_placeholders => '{ "ORDER_NUMBER": 5321, "ORDER_DATE": "01-Feb-2018", "ORDER_TOTAL": "$12,000" }',
  p_subject      => l_subject,
  p_html         => l_html,
  p_text         => l_text );
end;