Bursting e-mail delivery with subject and body parameterized
Hi,
according with the Oracle Documentation Adding Bursting Definitions - 11g Release 1 (11.1.1) I can create a parameter, definited into Data Model, and use it into Bursting Definition Query.
I would like use parameters for e-mail subject and e-mail body. Like this:
select distinct t.ID as "KEY", 'TemplateName' TEMPLATE, 'IT-it' LOCALE, 'pdf' OUTPUT_FORMAT, 'true' SAVE_OUTPUT, 'Rpt_bsp-'||rep_name||' '||To_Char(SYSDATE,'dd-mm-yyyy_hh24-mi-ss') OUTPUT_NAME, 'email' DEL_CHANNEL, t.EMAIL PARAMETER1, NULL PARAMETER2, 'publisher@oracle.com' PARAMETER3, :P_EMAIL_SUBJECT PARAMETER4, :P_EMAIL_BODY PARAMETER5, 'true' PARAMETER6 from email_addresses_rep t
But :P_EMAIL_SUBJECT