Calling Reports from Oracle Forms problem !!

[aj_usa]

Hello,

I wanted to check if I can call a report 6i from Forms 6i. I used this
Run_PRODUCT(REPORTS, 'report5', SYNCHRONOUS, RUNTIME,FILESYSTEM, NULL, NULL);

I get an error - Too many declarations of 'Run_product' Match this call

Is that not the way ?

Thanks

[jammula]

Hi raj,
There are so many ways of coding to call reports from forms

I normally use

Please use Run_report_object example in Oracle

That will help you with example
DECLARE
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status varchar2(20);
BEGIN
repid := find_report_object('report4');
v_rep := RUN_REPORT_OBJECT(repid);
END;

[stecal]

Workaround 2
------------
Declare an empty parameter list, and reference this in the RUN_PRODUCT call:
DECLARE p_id ParamList;
BEGIN
RUN_PRODUCT( REPORTS, 'empreport', SYNCHRONOUS, RUNTIME, FILESYSTEM, p_id, NULL );
END;

Workaround 3
------------
Use '', instead of NULL:
RUN_PRODUCT( REPORTS, 'empreport', SYNCHRONOUS, RUNTIME, FILESYSTEM, '', NULL );

The sixth argument is an empty string; hence, it is of datatype VARCHAR2, which tells Oracle Forms to expect a parameter list name.

Workaround 4
------------
Use named notation:
RUN_PRODUCT( REPORTS, 'empreport', SYNCHRONOUS, RUNTIME, FILESYSTEM, paramlist_name=>NULL, display=>NULL );