Tech Trainings

How to add multiple email addresses in the bursting control file

June 15, 2023 by admin

Sample Bursting Control File Query - With Multiple Email Addresses : 

SELECT
    1                                                      key,
    'sample template name'                                 template,
    'en-US'                                                locale,
    'excel'                                                output_format,
    'EMAIL'                                                del_channel,
    'output file name'                                     output_name,
    'sample@email.com,sample2@gmail.com,sample3@gmail.com' parameter1,
    'no-reply@test.com'                                    parameter3,
    'email subject'                                        parameter4,
    'sample email body'                                    parameter5,
    'true'                                                 parameter6
FROM
    dual

Error if email addresses are having issue : 
Email delivery failed with Exception
Email delivery failed with DeliveryException
javax.mail.internet.AddressException: Illegal semicolon, not in group in string 
oracle.xdo.service.delivery.DeliveryException: javax.mail.internet.AddressException: Illegal semicolon, not in group in string 

Comments |0|