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,
Lino

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.

4/4/2020 Part two of this post is available now IG with JS check on duplicate rows.

Happy APEXing,
Lino