FIND_REPORT_OBJECT question
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