Monday, October 22, 2012

Add popup message while request running

For debugging purposes you can use command SRW.MESSAGE inside pl/sql code when you are creating a report using report builder v.6 application.

i.e: Uses this command in BEFOREREPORT program unit for showing which value has P_PARAMETRO

SRW.MESSAGE(1,'PARAMETRO ' || :P_PARAMETRO);

full code:


function BeforeReport return boolean is
begin
   SRW.MESSAGE(1,'PARAMETRO' || :P_PARAMETRO);

   return (TRUE);

end;





Note: In parallel when form builder is used for creating a form you can add this line for add comment:
 dbms_output.put_line('PARAMETRO' || :P_PARAMETRO);