Parameterized views

Sometimes it would be easy to have a view which is parameterized. One of the options is to use sys_context. Another option is to makeuse of a pipelined function. Example package CREATE OR REPLACE PACKAGE okps_preop_tst IS TYPE outrec_typ IS Read more…

Refresh (plsql) Region Apex

A classic report in APex can be refreshed dynamically. A pl/sql region is more difficult, you must do this by using an application proces. Create a plsql region calling a procedure/package with htp.p-commands. IE <div id=HK3>xcvxvxvxvc</div> BEGIN show_data; END; create Read more…