Skip to Main Content

To-do List

A collection of things that still need to be done, or that would be nice to have, on this site.

Blocks

Do something nice with this, maybe on page 1067:

Reports

Read up on Report Queries & Report Layouts.

Copy/Paste Prevention

$(function(){
    $(document).on("cut copy paste","#P10_PAGE_ITEM",function(e) {
        e.preventDefault();
    });
});

Edition-Based Redefinition

Easy XLSX Parser: Just with SQL and PL/SQL

Process Excel sheets directly instead of having to convert to CSV: https://blogs.oracle.com/apex/easy-xlsx-parser%3A-just-with-sql-and-plsql

IE 11 Compatibility View

Internet Explorer 11 by default switches to "compatibility view" (aka: IE7+ActiveX rendering) for sites it detects as behind the firewall (what it calls "intranet").
I noticed this when working on a development system behind the firewall; that setting really messes up the layout...

There is a simple fix to disable this "feature" - just add this to the <head> html tag (in Apex that would be in the Header section of the Page template): <meta http-equiv="X-UA-Compatible" content="IE=Edge">

More info: https://github.com/cockpit-project/cockpit/issues/9269

classic report 100% width

.t-Report-wrap, .t-Report-report {
  width: 100%;
}

redirect

https://tedstruik-oracle.nl/ords/f?p=25384:1065:::NO:RP::

http://apex-smb.blogspot.com/2011/12/apexapplicationstopapexengine.html
2. It looks like stop_apex_engine will roll back any SQL inserts/updates/deletes that occur in the routine, where as g_unrecoverable_error allow them to be committed.

Connection Lost

Cursor c Is
    Select a.pk_id
        From a_table t
        Join a_view v On v.pk_id = t.pk_id.pk_id;
Gives “no connection to oracle” on database 12.2.0.1.0 and PL/SQl Developer 12.0.7. I cannot reproduce this on Database 18 XE and PL/SQL Developer 11.0.6.