Dear All,
i am using email APEX package in form with report page in APPLY CHANGES mode .
DECLARE
l_id number;
to_add varchar2(1000);
from_add varchar2(1000);
l_body varchar2(4000);
l_sub varchar2(1000):='Hotel Information';
meal varchar2(1000);
category varchar2(1000);
sr number;
dr number;
eb number;
hotel varchar2(1000);
chec date;
BEGIN
select email_id into from_add from user_mas where user_id=:app_user;
select EMAIL into to_add from HOTEL_MAS where code=:P13_SUPP_CODE and ACTIVE_FLG='Y';
select SUPP_CODE,SERVICE_DAY_IN into hotel,chec from TA_REQUEST_MAS where REQUEST_NO=:P13_REQUEST_NO and COSTING_CODE=:P13_COSTING_CODE AND FILE_CODE=:P13_FILE_CODE;
select MEAL_PLAN, ROOM_CATEGORY, NO_OF_SR, NO_OF_DR, NO_OF_EB INTO meal,category,sr,dr,eb FROM TOUR_COSTING_DTL WHERE COSTING_CODE=:P13_COSTING_CODE AND SERVICE_TYPE='Accommodation' AND REQUEST_NO=:P13_REQUEST_NO;
l_id:=APEX_MAIL.SEND(
p_to => to_add, -- change to your email address
p_from => from_add,
p_body =>'Hotel Information'||''||chr(13)||chr(10)||chr(13)||chr(10)||
'Hotel Name '||' '||':'||hotel||CHR(13)||chr(10)||
'Room Category '||' '||':'||category||CHR(13)||chr(10)||
'No of SR '||' '||':'||sr||CHR(13)||chr(10)||
'No of DR '||' '||':'||dr||CHR(13)||chr(10)||
'No of EB '||' '||':'||eb||CHR(13)||chr(10)||
'Meal Plan '||' '||':'||meal||CHR(13)||chr(10)||
'Check in '||' '||':'||chec||CHR(13)||chr(10),
P_subj => l_sub);
apex_mail.push_queue(
P_SMTP_HOSTNAME => '10.1.1.2',
P_SMTP_PORTNO => 25);
exception
when no_data_found then
htp.prn('Issue Create Successfully.');
END;
ORA-20001: You must supply a message recipient to send mail.
How to resolve it. and where should i put that Receipient Masage.
Thanks