An evaluation release has been uploaded to OTN. Check it out at OTN – APEX Migration Workshop.
There is also an interesting blog run by Donal Daly who is one of the developers of the migration workshop.
Be cautious if you use PL/SQL functions/packages in your SQL statements, especially in the Where-Clause!
Because the function is probably called more often than you think it is! If you don’t want to read the hole article, scroll down and check the APEX impact.
Did you know that when you reference a non existing APEX item in your SQL statements or PL/SQL code, that you are not getting a runtime error? APEX will just return NULL in such a case!
Did you know that you can use the Database Object Dependencies report of Oracle Application Express (APEX) to find PL/SQL code in your application which doesn’t compile? So that your users don’t get a runtime error.
Be aware when using bind variables or the V function to reference an Oracle APEX item in your SQL statements or your PL/SQL code that APEX/Oracle always stores this values as VARCHAR2’s in its internal arrays!
If yes, continue reading. If not, continue doing it again and again, … 😉
For example you like the “Standard, Alternating Row Colors” template for reports or you don’t want to write help texts (which developer does?) for your items, but the Oracle APEX builder always defaults the item to “Optional Label with Help”.
Just came again across a feature of Oracle Application Express (APEX) which is worth mentioning it.
Have you ever had the problem, that the page processing flow of Oracle APEX was different then what you thought it should be? And it took you some time to figure out how Oracle APEX is processing the page?
Have updated the blog entry about “Generic solution for depending select lists/lovs“. The description and the files cover now what do do in case of a version prior to 2.2.x.
Just curious, is somebody already using the solution in his APEX application?
Note: Before you read on, cascading LOVs are now natively implemented into APEX 4.0. See my related blog posting Oracle APEX 4.0: Cascading LOVs/Select Lists.