Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-20001: You must supply a message recipient to send mail.

VedantMar 16 2012 — edited Mar 16 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 13 2012
Added on Mar 16 2012
2 comments
2,983 views