APEX Essentials – Looking for early adopters

APEX Essentials – A great new tool on the Oracle APEX horizon…

What is it?

APEX Essentials is my current working title (might also be the final name) of a new open source project which includes essential Oracle APEX tools for your daily Oracle APEX application development.

The first tool of this collection is

The Oracle APEX Advisor

Ever had the problem that you referenced a non existing page item with the substitution- or bind variable syntax, but you didn’t notice because Oracle APEX just returns NULL in such a case without raising an error?

You did some data model or PL/SQL package changes and didn’t notice that you broke your APEX application code? If you are lucky you get a runtime error. In some cases you don’t event get that. Oracle APEX just ignores your invalid code… See OTN forum threads here and here.

APEX Advisor is some kind of a “compiler” for your Oracle APEX application. It goes through your applications meta data and performs a variety of checks. Some of them are to find invalid PL/SQL code or invalid references to page items, but others are more kind of “Best Practice” checks like

don’t use V/NV in SQL statements

unconditional branches before conditional ones

…

Currently there are a total of 22 checks which are performed! And the good news is that it has a plugin system so that you can add your own QA checks!

Want to take a quick look?

I have set up a demo workspace on apex.oracle.com where I have uploaded most of the Packaged Applications which are provided by the Oracle APEX team. So you can try it online first, before you request a beta copy.

Login with

Workspace: ae_demo
User: guest
Password: 123456

and run the application “APEX Essentials”. If you are prompted for a username/password enter guest/123456

Note: Don’t change anything in this workspace!

You can also directly run it, but then it’s not integrated into the Oracle APEX Builder.

2 thoughts on “APEX Essentials – Looking for early adopters”

Congratulations! I Would love to try APEX Essentials tool. I will give it a try on apex.oracle.com and let you know if we can participate in beta. I am on and off on a business trip in February/March and hence our beta participation might have to wait.