HOW IS IT POSSIBLE TO GET CURSOR VARIABLES IN P_BODY_HTM OF APEX_MAIL

HI,

i have apex 4.2.6 on AIX and http server on windows.

i would like to pass cursor variable in p_html_body of apex_mail, but impossible.

it's ok with p_body

here's my pl sql

declare

l_id_ann number;

l_tit_ann varchar2(40);

l_id number;

l_body_html CLOB;

l_body CLOB;

BEGIN

FOR C1 in (select  a.ID_ANN, a.IDF_AGENT, a.DATE_ANN, substr(a.TITRE_ANN,1,30) titre_ann, b.nom,

b.email,

c.lib_categ

from v_ANNONCES a,v_agents_interf b,v_ann_categ c,v_suivi_ann d

where

a.idf_agent=b.idf_agent