How to do email bursting without sending an attachment

Niharika Bojanapalli

I am writing the bursting logic to send a text file .

I dont want the text file to be attached in the email.

Logic:

(select 'DATA' KEY

  ,'Billing' TEMPLATE

  ,'eText' TEMPLATE_FORMAT

  ,'en-US' LOCALE

  ,'TEXT' OUTPUT_FORMAT,

'EMAIL' DEL_CHANNEL,

'abc'||:P_MODE||'_'||TO_CHAR(SYSDATE, 'YYYYMMDDHH24MISS') OUTPUT_NAME,

'xx@abc.com' PARAMETER1, -- to_email

'no-reply@oracle.com' PARAMETER3,

'test email' PARAMETER4,

'Process completed successfully

 PARAMETER5,

'FALSE' PARAMETER6

FROM dual)

Even the parameter6 is set to false, the file is still getting attached

Hamed Tolan

 ,'eText' TEMPLATE_FORMAT

must be HTML not EText

user8139220

please share the logic of query content in mail body. urgent

Riyaz Ali-Oracle

1. Ensure TEMPLATE_FORMAT is Set Correctly

TEMPLATE_FORMAT = 'HTML' instead of 'eText' that prevents attachments from being included.

2. Modify the Delivery Channel

Instead of 'EMAIL', try using 'NONE' or another delivery method that doesn’t generate attachments.