Re: Forms 5.0: Parameters for RUN_PRODUCT

[Quoted] On Tue, 8 Sep 1998 16:43:49 -0500, "Todd Owers" <toddo_at_gcr1.com> wrote:

>I am bringing into Forms 5.0.6.8.0 a form that was originally developed in
>Forms 4.5.7.1.6. I have a When-Button-Pressed trigger that calls a report
>using the RUN_PRODUCT built-in. Because this particular report does not use
>a parameter list, I set the appropriate parameter to NULL as follows:
>
>RUN_PRODUCT (REPORTS, 'my_report.rdf', SYNCHRONOUS, RUNTIME, FILESYSTEM,
>NULL);
>
>This code compiled successfully in Forms 4.5; however in 5.0 I get PL/SQL
>Error 307, 'Too many declarations of RUN_PRODUCT match this call.'
>
>What is going on here? Thanks in advance for the help.
>
>Todd Owers
>toddo_at_gcr1.com
>
>
>
>
>

[Quoted] NO matter what you need to use parameter list.... like

DECLARE
  pl_id ParamList;
BEGIN
  pl_id := Get_Parameter_List('tmpdata');   IF NOT Id_Null(pl_id) THEN
    Destroy_Parameter_List( pl_id );
  END IF;
  pl_id := Create_Parameter_List('tmpdata');

  add_parameter(pl_id, 'PARAMFORM', text_parameter, 'NO');
  add_parameter(pl_id, 'DESTYPE',   text_parameter, 'PRINTER');
  add_parameter(pl_id, 'ACCTNO',    text_parameter,

  run_product(reports, '...', synchronous, runtime,   filesystem, pl_id, null);
  run_product(reports, '...', synchronous, runtime,   filesystem, pl_id, null);

END; Received on Sun Sep 20 1998 - 09:29:43 CEST