APEX Application Upgrades:
Out With The Old, In With The New

Jeff Eberhard

 

About Me

 

  • Senior APEX Consultant
  • Insum Solutions
     
  • Blog: blog.eberapp.com
  • Email: jeff@eberapp.com
  • Twitter: @eberhje

 

 
Oracle APEX expert practice since 2004
▶ Oracle APEX Center of Excellence
▶ Comprehensive Consulting Services
► Training & Coaching
► Architecture & Analysis
► Project Management
► On-site / Off-site Development
► APEX Best Practices and Methodologies
▶ Offices in Canada and USA
▶ Our Core Values : Respect, Teamwork, Integrity, Innovation, Quality and Fun ! 

 

  Agenda

  • Why?
     
  • Advisors
     
  • Manual Upgrades
    • Compatability Modes
       
    • Old Ways vs. New Ways

 

 

Why Upgrade?

 

  • Security
     
  • Clarity
     
  • Maintainability
     
  • Performance
     

(YABAOAE) Yet Another Blog About Oracle Application Express (http://joelkallman.blogspot.com)

The Ideal APEX Application (When & Where You Write Code)

  1. Use the declarative features of APEX as much as possible, don't write code.
  2. When you need to venture outside the declarative features of APEX and you need to write code in PL/SQL, be smart about it.
  3. Avoid huge sections of JavaScript and use Dynamic Actions wherever possible.
  4. APEX is just a thin veneer over your database - architect your APEX applications as such.

How do you Upgrade?

 

  • APEX Application Advisor / APEX Upgrade Advisor
     
  • Manually identify components to upgrade

APEX Application Advisor

 

 

APEX Upgrade Advisor

 

 

APEX Release Notes

  • Changed Behavior
     
  • New Features
     
  • Functionality No Longer Supported
     
  • Open Bugs and Known Issues

 

Release Notes 4.2

Release Notes 5.0 beta

Compatibility Mode

  • 4.2
     
  • 4.1
     
  • Pre 4.1

Remove Legacy Javascript

 

 

Why?

  • Avoid possible future security implications
  • Reduce size of library loaded per page view

 

legacy.js

 

Old vs. New

Cascading Select Lists

 

Old vs. New

Autofill Item Values

 

 

Conclusion

Thank You!

Jeff Eberhard
Email: jeff@eberapp.com
Blog: blog.eberapp.com
Twitter: @eberhje