APEX

Hi,

is it possibile to get query string from “PL/SQL function body returning string query” type region?

I can get region definition as a PL/SQL procedure, but I’m interested in returned query. I tried to write something like

<pre>v_return_query:=’….’;
:P49_QUERY:=v_return_query;
return v_return_query;</pre>

to save returning string to hidden item P49_QUERY, but it doesn’t work. I’m getting error: ERR-1002 Unable to find item ID for item "P49_QUERY" in application "4000".

Regards,
Przemek