Getting collection into varchar2 variable

[jmodic]

Once you have collected all the inactive employees into your varray, simply loop through all its ellements and concatenate the employees into a variable. Something like this:

...
my_variable := 'Inactive employees: ';
for i in 1..my_varray.LAST loop
  my_variable := my_variable || ', ' || my_varray(i).ename;
end loop;
-- now send the message with my_variable as a body
...