problem in run_report_object (error : frm-40738)

From: KULJEET <kuljeet_twtpl_at_hotmail.com>
Date: 7 Jun 2003 02:48:55 -0700
Message-ID: <febbed51.0306070148.79717ecf_at_posting.google.com>

[Quoted] I HAVE USE RUN_REPORT_OBJECT METHOD ON WEB TO RUN REPORT FROM FORM. IT WILL WORK FINE FROM GIVEN EXAMPLE.
DECLARE
 REPID REPORT_OBJECT;
 REP_JOB VARCHAR2(100);
BEGIN

set_report_object_propert (repid,report_execution_mode,batch);
set_report_object_propert (repid,report_comm_mode,asynchronus);
set_report_object_propert (repid,server,'repserver');
rep_job:=run_report_object(repid);

END;
the report will run fine.

BUT WHEN I USE METHOD REPORT_OBJECT_STATUS TO CHECK THE STATUS OF REPORT THEN IT WILL GIVE ERROR

---

FRM-40738 ARGUMENT 1 TO BUILTIN REPORT_OBJECT_STATUS CAN NOT BE NULL

---

DECLARE
 REPID REPORT_OBJECT;
 REP_JOB VARCHAR2(100);
 REP_STATUS VARCHAR2(100); BEGIN

set_report_object_propert (repid,report_execution_mode,batch);
set_report_object_propert (repid,report_comm_mode,asynchronus);
set_report_object_propert (repid,server,'repserver');
rep_job:=run_report_object(repid);
rep_status:=report_object_status(repid);

  if rep_status='FINISHED' then
    message('report complete');
elsif rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED') THEN   null;
else
  message('report has failed');
end if;

END;
plz help me. Received on Sat Jun 07 2003 - 11:48:55 CEST