set serveroutput on
declare

a_list pkg_mail.addr_list%type;

begin
/***************************************************/
/* Set multiple addresses for multiple sends below */
/***************************************************/
a_list(1) := 'myemailaddress@mydomain.com';
a_list(2) := 'anotheremailaddress@mydomain.com';

/*============================================*/
/* send a text message to multiple recipients */     
/*============================================*/
dbms_output.put_line('Single Text');
pkg_mail.send_mail('myemailaddress@mydomain.com',
		'myemailaddress@mydomain.com',
		'Test1',
		'This is a PL/SQL Generated Email',
		null);
/*============================================================*/
/* send a text message abd query result to a single recipient */     
/*============================================================*/
dbms_output.put_line('Single Text/Query');
pkg_mail.send_mail('myemailaddress@mydomain.com',
		'myemailaddress@mydomain.com',
		'Test1',
		'This is a PL/SQL Generated Email',
		'select ''Today is ''||sysdate from dual');

/*============================================*/
/* send a text message to multiple recipients */     
/*============================================*/
dbms_output.put_line('Multiple Text');
pkg_mail.send_mail(a_list,
		'myemailaddress@mydomain.com',
		'Test1',
		'This is a PL/SQL Generated Email',
		null);
/*============================================================*/
/* send a text message abd query result to a single recipient */     
/*============================================================*/
dbms_output.put_line('Multiple Text/Query');
pkg_mail.send_mail(a_list,
		'myemailaddress@mydomain.com',
		'Test1',
		'This is a PL/SQL Generated Email',
		'select ''Today is ''||sysdate from dual');

end;
.
/