APEX

Hello,

I have a long sql-statement in a region source.
The type ist "SLQ Query(PL/SQL function...)

Example of my code:
*********************************
declare q varchar(4000);
begin
q:= ' SELECT org ';

If :P110_EMPLOYEE = '%null%' and :P110_WRKCTRL1 = '%null%' then q:=q||' BUKRS Name, '; else null;
end if;

q:=q||' FROM csdb.v_user_org, csosap.pa2_mon a WHERE 1=1';

if :P110_WRKCTRL1 <> '%null%' then q:=q||' and ARBPL = :P110_WRKCTRL1 '; else null; end if;

return q;
end;
*********************************

In "q" ist the long sql string. Now I get some error messages.
It is very difficult to find a solutions because "q" ist very long.

Is it possible, to get someting like messagebox. popup or print a file to see what's in "q" (the sql stringer)?

Thanks a lot.
Andre