Oracle Reports (MOSC)

MOSC Banner

run_report_object no report produced depending on user

edited Apr 24, 2012 1:24AM in Oracle Reports (MOSC) 1 commentAnswered ✓
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/';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center