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:

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.

APEX Project Eye

APEX Project Eye
APEX Project Eye combines interactive, drill-down page summaries, graphical page flow diagrams, automatic documentation generation, database object dependency information, and session tracing, making it easy to see how an application is built, what it depends on, who is using it and how.