How to send 2 Excel Files as attachments using UTL_MAIL package from PL/SQL Query outputs?
I am having 2 separate PL/SQL Query outputs. I want to send these results as 2 separate EXCEL file attachment in oracle using UTL_MAIL package in Oracle 19c using TOAD for Oracle Expert 14.1.120?
CREATE OR REPLACE PROCEDURE send_email_delete_me (
in_sender IN VARCHAR2,
in_recipients IN VARCHAR2,
subject IN VARCHAR2,
attachments IN VARCHAR2)
IS
add_date VARCHAR2 (50) := TO_CHAR (SYSDATE, 'DD/MM/YYYY');
v_sub VARCHAR2 (100) := subject;
v_body VARCHAR2 (2000)
:= 'Dear User,
Please find the attached vaccination feedback data. This is an auto system export for your report.
Best Regards,
IS Dept Vaccination Support
';
BEGIN
UTL_MAIL.SEND_ATTACH_VARCHAR2 (