Skip to Main Content

Analytics Software

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!

How to do email bursting without sending an attachment

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

This post has been answered by Hamed Tolan on Nov 17 2022
Jump to Answer
Comments
Post Details
Added on Feb 23 2022
1 comment
1,589 views