FIND_REPORT_OBJECT question

From: <dirk_101_at_hotmail.com>
Date: Fri, 24 Mar 2000 13:47:50 GMT
Message-ID: <8bfrm1$l62$1_at_nnrp1.deja.com>



Hi there,

I'm using Developer 6.0 and try to call a Report from Forms via RUN_REPORT_OBJECT.
I use the following syntax:

DECLARE
report_id Report_Object;
report_job_id Varchar2 (100);
BEGIN

report_id := FIND_REPORT_OBJECT('REP01');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'HTML');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'REPSERV');

report_job_id := RUN_REPORT_OBJECT(report_id); END; REP01 is a report compiled as rep01.rep. REPSERV is the entry in the tnsnames.ora:

REP60.world, REPSERV.world = ...

Also, a file in the .\REPORT60\SERVER directory called repserv.ora exists.

The fmx file and the rep60.rep file are located in the same directory. Okay, when I call the statement
report_id := FIND_REPORT_OBJECT('REP01'); I get FM-41219 (cannot find report: invalid ID).

When debugging the form, the FIND_REPORT_OBJECT statement doesn't return anything into the report_id variable.

Where's my mistake? Do I have to specify any directory entries that Forms finds the report and assigns the report_id variable with the correct information?

Thanks in advance.
Dirk

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Mar 24 2000 - 14:47:50 CET

Original text of this message