Sunday, 14 January 2018

Oracle APEX 5.1.4 and ORDS 17.4 upgrade

Oracle APEX 5.1.4 and ORDS 17.4 upgrade


Weblogic 10.3.6 and ORDS 17.4

Webserver and ORDS JAVA compatibility issue

This popped out during our ORACLE APEX 5.1.4 upgrade

We were running WebLogic 10.3.6 and Oracle APEX 5.1.2 doing upgrade to latest version of ORDS and APEX (ORDS 17.4 and APEX 5.1.4)

APEX upgrade as such was smooth but on ORDS restart we got an error:

Problem was in JAVA version that was running on our WebLogic Server -> JAVA version 7(
jdk1.7.0_25) was not supported by ORDS.

More info here

Solutions available:
- Downgrade to use ORDS 17.3
- Upgrade your WebLogic with JDK 1.8
- Upgrade your WebLogic to 12c

We decided (for now) to go with ORDS 17.3 and APEX was up and running again.

Happy APEXing,

Tuesday, 12 December 2017

Interactive grid validation

APEX and IG validation


Interactive grid validation

Check for duplicates

Something that come out today as a question - How to validate Interactive grid to check if your user typed primary key like EMPNO is not already in the table?  

Catch was to do this only on insert as people will not be able to delete or update it afterwards.

Adding a validation to your IG is easy enough, creating one as:

Where PLSQL Function body code is:

That is all. Notice the use of APEX$ROW_STATUS to detect if row is created.

Happy APEXing,