declare
	v_utl_filehandler	UTL_FILE.FILE_TYPE;
   	v_rawfile			RAW(32767);
    v_size			 	NUMBER;
    v_block				NUMBER;
    v_boolean			BOOLEAN;
	v_file_dir			varchar2(100);
	v_file_name			varchar2(100) := 'EXT_GALA_20071123105532_20071127130013.txt';
	v_transfer_location varchar2(100) := 'gary.coles@ingg.com, timothy.cassidy@ingg.com';
begin	
	v_file_dir := 'DIR_BILLING_DATA';
	v_utl_filehandler := UTL_FILE.FOPEN(v_file_dir, v_file_name, 'r');
	UTL_FILE.fgetattr(v_file_dir, v_file_name, v_boolean, v_size, v_block);
	UTL_FILE.get_raw(v_utl_filehandler, v_rawfile, v_size);
	UTL_FILE.FCLOSE(v_utl_filehandler);

 	sys.utl_mail.send_attach_raw( sender 		=>	'Legion BDS - '||ora_database_name||' <legiondw@inspiredbroadcast.net>'
 								, recipients 	=>	v_transfer_location
 								, subject 		=>	'Legion BDS - Transfer Billing Group File'
 								, message 		=>	'Dear Client'||CHR(13)||CHR(13)||
 													'Please find attached this periods billing file.'||CHR(13)||CHR(13)||
 													'If you have any issues with this billing file please contact the Legion BI Team on bi-team@inspiredbroadcast.net'||CHR(13)||CHR(13)||
 													'Cheers'||CHR(13)||
 													'BI-TEAM'||CHR(13)||CHR(13)
 								, attachment	=>	v_rawfile
 								, att_inline	=>	FALSE
 								, att_filename	=>	v_file_name
 								);
end;