How to Email a Report Through ORACLE 10g FORM

To discuss Oracle Forms & Reports related technical issues.
Post Reply
nmdevorah
Posts: 3
Joined: Mon Jan 28, 2013 2:36 am
Location: New Zealand

How to Email a Report Through ORACLE 10g FORM

Post by nmdevorah »

Dear All i want to email a report through oracle 10g FORM plz give me any hint or help...

my Report code below how do i add email code to send email directly to client


DECLARE
v_report_id Report_Object;
vc_report_job_id VARCHAR2(100);
vc_rep_status VARCHAR2(100);

BEGIN

v_report_id:= FIND_REPORT_OBJECT('report1');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);

SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT, 'pdf');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER, '<ReportServerTnsName>');
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_OTHER, 'paramform=no');
vc_report_job_id:=RUN_REPORT_OBJECT(report_id);

vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
IF vc_rep_status='FINISHED' THEN
web.show_document ('/<virtual path>/<reports cgi or servlet name>/getjobid='||
vc_report_job_id ||'?server='|| '<ReportServerTnsName>','_blank');
ELSE
message ('Report failed with error message '||rep_status);
END IF;
END;
nmdevorah
Posts: 3
Joined: Mon Jan 28, 2013 2:36 am
Location: New Zealand

Post by nmdevorah »

use less forum.....):
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests