send view/ table in email
935316May 18 2012 — edited May 21 2012Am trying to send an email from apex with a view, but I dont know how to include it in the mail body...
This what I use as process when click on button...
DECLARE
CURSOR EMP_CURSOR IS SELECT email FROM employee;
l_id NUMBER;
BEGIN
FOR Emp_REC IN EMP_CURSOR
LOOP
l_id := APEX_MAIL.SEND(
p_to => Emp_REC.EMAI,
p_from => 'xxxx@hotmail.com',
p_subj => 'employee information',
p_body => '????');
end loop;
I want to include emp_info view in the mail... that will display in the body.. Can you please help me?