Home » Developer & Programmer » Forms » Sending report as attachment from forms (Oracle Forms & Reports 11g, Windows)
Sending report as attachment from forms [message #675688] Fri, 12 April 2019 04:21
saiphani723
Messages: 38
Registered: July 2006
Location: Hyderabad
Member
I am using the below code to send report as attachment through mail.

Add_Parameter(Pl_Id,'REPORTFORM', TEXT_PARAMETER,'NO');
Add_Parameter(Pl_Id,'PARAMFORM', Text_Parameter, 'NO');
Add_Parameter(Pl_Id,'PCOMPANYCODE',Text_Parameter,:Global.CompanyCode);
Add_Parameter(Pl_Id,'PUNITCODE',Text_Parameter,:Global.UnitCode);
Add_Parameter(Pl_Id,'PFUNDTYPE',Text_Parameter,:Parameter.FundType);
Add_Parameter(Pl_Id,'PFROMRECEIPTNO',Text_Parameter,:Parameter.ReceiptNo);
Add_Parameter(Pl_Id,'PLINKID',Text_Parameter,:Master.LinkId);
Show_View('EMAIL');
Rp2rro.setDestype('mail');
Rp2rro.setDesformat('pdf');
--Rp2rro.setDesname('saiphani723@gmail.com');
Rp2rro.setDesname(:Control.EmailId);
ADD_PARAMETER(Pl_Id, 'FROM',TEXT_PARAMETER, pSender);
ADD_PARAMETER(Pl_Id, 'SUBJECT',TEXT_PARAMETER, 'Receipt for '||:Master.ReceiptNo);
ADD_PARAMETER(Pl_Id, 'BODY',TEXT_PARAMETER, 'TEST MAIL');
ADD_PARAMETER(Pl_Id, 'MESSAGE',TEXT_PARAMETER, 'TEST MAIL');

RP2RRO.RP2RRO_RUN_PRODUCT(REPORTS,LvReportId,SYNCHRONOUS,RUNTIME,FILESYSTEM,PL_ID,null);

Report is attaching as pdf and sendin mail But no body/message coming in the mail. Can you please suggest how to send some mail body using the above code.
Previous Topic: slow laoding webutil package just the first time
Next Topic: Temporary table in forms
Goto Forum:
  


Current Time: Thu Mar 28 07:35:56 CDT 2024