How to attach multiple files in UTL_MAIL.SEND_ATTACH_VARCHAR2 method
910815Jan 13 2012 — edited Jan 13 2012Hi all ,
I had written a pl/sql where it will write multiple csvs i.e. a.csv,b.csv,c.csv,d.csv to a location using UTL_FILE to reports folder .
How do i attach a.csv,b.csv,c.csv,d.csv into a single mail ??
UTL_MAIL.send_attach_raw (sender => 'sender@abc.com.sg',
recipients => 'recepient.com.sg',
subject => 'Reports',
MESSAGE => 'Reports are attached above',
mime_type => 'text/html; charset=UTF8',
attachment => a.csv,
att_inline => FALSE,
att_filename => file1
);
Edited by: 907812 on 12-Jan-2012 23:03
Edited by: 907812 on 12-Jan-2012 23:03
Edited by: 907812 on 12-Jan-2012 23:04
Edited by: 907812 on 12-Jan-2012 23:04