Re: problem in run_report_object (error : frm-40738)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 8 Jun 2003 17:17:25 +0200
Message-ID: <ve75u81p96889d_at_corp.supernews.com>


"KULJEET" <kuljeet_twtpl_at_hotmail.com> wrote in message news:febbed51.0306070148.79717ecf_at_posting.google.com...
> 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.

The message tells the parameter to the procedure can not be null. This implies in your situation the repid IS actually NULL You have local variable repid, and you don't assign a value to it anywhere, hence it is NULL

-- 
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Sun Jun 08 2003 - 17:17:25 CEST

Original text of this message