I am generating oracle report through command line and email the report. I need to know how to add body content for this email.
Following command generate PDF file with password and mail it to the relevant e mail address.Your support highly appreciated at this moment.
host('rwclient server=ReportsServer_hawaii_a report=test.rdf userid=sms/sms987@test1 desformat=pdf DESTYPE=mail DESNAME="email@example.com" SUBJECT="Monthly Data" PDFUSER="passme" P_Client_ID="'||I.CLIENT_ID||'" YEAR_MONTH="JAN-2012" replyto="XMAMMAYY@gmail.com" from="e-statement@ABCdemo.lk"');
Above command loop inside a cursor(I) and this code work without any issue.
You can use distribution xml file to add body content to Email. Please refer these link for details:
20.5 Distribution XML File Examples
If your reports version is 11g or 11gr2 then refer this document for password protected pdf: