APEX patchset 5.0.2. was released with a few important fixes in it (less than the 5.0.1 patchset at first glance), a few stand-out ones that caught my eye were:
- 21479385 – APEX_WEB_SERVICE.MAKE_REST_REQUEST results in ORA-06502 if P_BODY pass as Null
- 21531843 – apxremov.sql does not remove all public synonyms
- 21882834 – APEX_JSON: Invalid Output when combining Write(Cursor) with other writes (I hit this one)
- 21901376 – ORA-06502 when calling APEX_UTIL.PREPARE_URL in classic report query (I also hit this one)
As always it’s worth checking out the known issues before you install, but I’d definitely recommend installing this patch (I did and haven’t noticed any adverse effects).