procedure enviar_email_alimento as
conn utl_smtp.connection;
v_target VARCHAR2(256);
BEGIN
v_target := 'arrr.cin@gmail.com, ' ||
'tmlp.cin@gmail.com, ' ||
'tcs5cin@gmail.com, ' ||
'julianalucenaa@gmail.com, ' ||
'fltiago@gmail.com ';
conn := demo_mail.begin_mail(
sender => 'André Ricardo <arrr.cin@gmail.com>',
recipients => v_target,
subject => '[BDA] ESTOQUE DE ALIMENTOS',
mime_type => 'text/html');
demo_mail.write_text(
conn => conn,
message => '<h1>Confira o estoque de alimentos!</h1>');
demo_mail.end_mail( conn => conn );
END enviar_email_alimento; |