run_report_object no report produced depending on user
Hi,
I have the following code in a form to call a report on the ias server.
PROCEDURE run_report (v_report_name in varchar2, v_output_name in varchar2)
IS
V_server varchar2(100);
V_user varchar2(100);
V_destype varchar2(100);
V_desformat varchar2(100);
V_report varchar2(100);
V_desname varchar2(100);
V_despath varchar2(100);
V_repname varchar2(100);
V_reppath varchar2(100);
rep_list ParamList;
report_id report_object;
report_job_id varchar2(200);
V_AL_ID ALERT;
V_DUMMY NUMBER;
BEGIN
-- Linux settings
V_report:='REPORT133';
V_server:='rep_iastest_oracleas1';
V_destype:='FILE';
V_desformat:='PDF';
V_despath:='/u01/app/oracle/OraASHome_1/forms/cosacs/reports/plot_reports/';
I have the following code in a form to call a report on the ias server.
PROCEDURE run_report (v_report_name in varchar2, v_output_name in varchar2)
IS
V_server varchar2(100);
V_user varchar2(100);
V_destype varchar2(100);
V_desformat varchar2(100);
V_report varchar2(100);
V_desname varchar2(100);
V_despath varchar2(100);
V_repname varchar2(100);
V_reppath varchar2(100);
rep_list ParamList;
report_id report_object;
report_job_id varchar2(200);
V_AL_ID ALERT;
V_DUMMY NUMBER;
BEGIN
-- Linux settings
V_report:='REPORT133';
V_server:='rep_iastest_oracleas1';
V_destype:='FILE';
V_desformat:='PDF';
V_despath:='/u01/app/oracle/OraASHome_1/forms/cosacs/reports/plot_reports/';
0