Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
,'eText' TEMPLATE_FORMAT
must be HTML not EText
0 -
please share the logic of query content in mail body. urgent
0 -
- 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.
0
