Re: Forms 5 Run_Product problem

A complete listing of When-Button-Pressed follows. If you need more details please email to brenogomes_at_computer.org

DECLARE
   param_list_id ParamList;
   param_list_name varchar2(20) := 'forneced_pl';    sql_stat varchar2(255);

BEGIN

• verifica se a lista de parametros ja existe param_list_id := GET_PARAMETER_LIST(param_list_name); IF NOT ID_NULL(param_list_id) THEN MESSAGE('Erro: a lista de parametros ' || param_list_name || ' já existe.'); RAISE FORM_TRIGGER_FAILURE; END IF;
• constroi a lista de parametros param_list_id := CREATE_PARAMETER_LIST(param_list_name); IF ID_NULL(param_list_id) THEN MESSAGE('Erro: a lista de parametros ' || param_list_name || ' não pode ser criada.'); RAISE FORM_TRIGGER_FAILURE; END IF;
• controi a condicao sql_stat := ' ORDER BY FORNECEDOR.DESIGNACAO ASC';
• coloca a condicao na lista de parametros ADD_PARAMETER(param_list_id, 'WHERE_CLAUSE', TEXT_PARAMETER, sql_stat);
• executa o oracle report RUN_PRODUCT(REPORTS, 'forneced', ASYNCHRONOUS, RUNTIME, FILESYSTEM, param_list_id, NULL);
• detroi a lista de parametros DESTROY_PARAMETER_LIST(param_list_id); EXCEPTION WHEN OTHERS THEN Message('Ocorreu um erro durante o evento WHEN-BUTTON-PRESSED.'); RAISE FORM_TRIGGER_FAILURE; END;

++++++++++++++++++

> I am upgrading a Forms 4.5/Reports 2.5 application to Forms
> 5.0/Reports 3.0
> My problem is that Oracle has apparently changed the syntax of the
> Run_Product command. Does anyone have an example of code that will
> run a report under 5.0? All the examples I have found generate a 307
> "Too many declarations of Run Product match this call" error.
>
> The exact syntax of my PL/SQL is
>
> Run_product(REPORTS,'c:\report.rep',ASYNCHRONOUS,RUNTIME,FILESYSTEM,NULL);
>
> Thanks
>
> Andrew Adams
Received on Thu Mar 11 1999 - 02:17:09 CET