PL/SQL (MOSC)

MOSC Banner

How to send 2 Excel Files as attachments using UTL_MAIL package from PL/SQL Query outputs?

in PL/SQL (MOSC) 2 commentsAnswered

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 (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center