declare
	m varchar2(100);
	rfile RAW (32767) := HEXTORAW('616262646566C2AA');
begin
	
	m:='leave_report_' || :HR_STAFF_LEAVE.LV_ID ||'.pdf';
	desname:='F:\ORACLE\HR_SYS\'||n||'.pdf';

utl_mail_oracle.send_attach_raw(
     sender=>[email]'wajid-nawaz@hct.edu.om'[/email],
     recipients=>[email]'charu@hct.edu.om'[/email],
     cc=>[email]'sivakumar.sadanandam@hct.edu.om'[/email],
     bcc=>[email]'charuamit@gmail.com'[/email],
     subject=>'Leave Application Report',
     message=>'Dear Sir/Madam !This is to inform you that a Leave Application is send for your approval',
     mime_type=>'text;charset=us-ascii',
     priority=>3,
     attachment=>rfile,
     ATT_INLINE => FALSE,
     att_mime_type=>'application/pdf',
     att_filename=>m);
     
     message('mail sent ');
      
exception
	when others then
	message(sqlcode || sqlerrm);
end;