| unable to run report or unable to get report job status ? [message #90336] |
Mon, 31 January 2005 03:35  |
Mohan G
Messages: 36
Registered: August 2004
|
Member |
|
|
hell to all
i am using reports 9i release 2 (no patches installed)
the database is on the linux system and i am running report from win/2000 system.
i trying to call a parameterized report from my form Test with a block block3 . when i try to show the report when a button is pressed its giving error message like "unable to run report" and "unable to get report job status".
how i have to trouble shoot my code ?.
please some one guide me
please check for the code below i have written to call the report
i am using
thanks in adv.
Mohan G
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
pl Varchar2(10);
Pl_id paramlist;
VarFileName Varchar2(1000);
VarSetFName Varchar2(1000);
BEGIN
if Trim(':Block3.Txtinvno') is not null then
pl_id:=create_parameter_list('invList');
add_parameter(pl_id,'P_invno',text_parameter,':Block3.Txtinvo');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rserver90');
v_rep := RUN_REPORT_OBJECT(repid,pl_id);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('http://sylnvb2:8888/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=rserver90','_blank');
ELSE
message('Error when running report');
END IF;
else
Message('Give correct InvNo or select from the list');
Message('Give correct InvNo or select from the list');
Go_Item(':Block3.txtinvno');
end if;
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
end if;
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
