Download from database

htp.init; — The mime header indicates what the type of the file is (browser will react on that) owa_util.mime_header(r_bfe.filetype, false); — use Content-Disposition: attachment to open a dialog box or inline to open in place htp.p(‘Content-disposition: attachment; filename=’||r_bfe.filename); htp.p(‘Content-length:’||dbms_lob.getlength(r_bfe.content) ); Read more…

Remove HTML-code

Removing/finding HTML-code using regular expressions: SELECT regexp_replace(name, ‘<.*?>’)  name_without_tags FROM table WHERE regexp_like(name, ‘<.*?>’)    

Close Child Window

Closing a child (pop) window called by using javascript. Parent javascript: popup=window.open(“https://dvrr.gs.ing.net/dvrr1/fp=110:2″,””,”location=no,toolbar=no,menubar=no,status=no, resizable=1,width=700,height=500″); window.onunload = function() { if (popup && !popup.closed) { popup.close(); } };

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…