DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Calling Reports from Oracle Forms problem !!

  1. #1
    Join Date
    Dec 2001
    Posts
    96

    Unhappy 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

  2. #2
    Join Date
    Jun 2002
    Posts
    10
    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;

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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
  •  


Click Here to Expand Forum to Full Width