run reports from forms

[vchen7]

Hi,
I run reports from forms with something alike :
"
set_report_object_property(repid, REPORT_OTHER, param_string);
v_rep := RUN_REPORT_OBJECT(repid);
"

I call a reports from the forms, this reports call in Before-Report Trigger, a function in a library LIB-REP, attached to this reports.

When I run the forms it goes in error :
REP 1401 'beforereport' : fatal error
ORA 06508 PL/SQL : could not find program unit being called
Any help please?

Thanks a lot!!
Vincent

 

[sem]

Is LIB-REP location listed in REPRTSxx_PATH?

Regards, Dima

http://seminihin.narod.ru

 

[vchen7]

Hi sem,
I have found a solution.
In the forms running the reports, add the command-line parameter recursive_load=no as follows :

"
declare

repid REPORT_OBJECT;
v_rep varchar(100);
param_string varchar2(400):= null;
filename varchar2(15):= 'MY_REPORT';

begin

repid := find_report_object('REP');
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_FILENAME, filename);
param_string := param_string||' PARAMFORM=NO ORACLE_SHUTDOWN=YES RECURSIVE_LOAD=NO';
set_report_object_property(repid, REPORT_OTHER, param_string);
v_rep := RUN_REPORT_OBJECT(repid);

end;
"

The default value of recursive_load is set to YES. In this case, "reports runtime tries to force a recompile instead of assuming all the PL/SQL references are valid" quoted from metalink.

Thanks for your interest,
Vincent.