Run Report Server Reports From PL/Sql Script
DECLARE V_Start_Date_Time VARCHAR2(100); V_Gateway VARCHAR2(1000) :='http://reportstest/reports/rwservlet/'; V_Desname VARCHAR2(4000); V_Des_Server VARCHAR2(4000) :='\\testserver.net\01\Files\AR\XXREPORTS\02\'; --Location of the server to store the Report output we can also pass the email id like xx@maildomain.com V_Filename VARCHAR2(1000); V_Userid VARCHAR2(100):= apps/apps@scott ; --Database login credentials v_apsuid VARCHAR2(100) :=; V_Paramlist srw_paramlist; V_Job_Ident srw.Job_Ident; V_Sta_Ident srw.Status_Record; BEGIN For I_Index in (SELECT * FROM xxAP_INVOICES WHERE 1=1 AND ORG_ID =83 --AND TRUNC(cre...