-
Calling Reports from Oracle Forms problem !!
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
-
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;
-
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 );
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|