Tuesday, October 25, 2016

Changed behaviour in APEX5: APEX_PLUGIN_UTIL.CLEANUP_PAGE_ITEM_NAMES

Unfortunately some things have to be learned in a hard way.

As I'm doing another APEX 4.2 to APEX 5 migration I just learned that there's changed behaviour in function apex_plugin_util.cleanup_page_item_names. Unfortunately, not documented.

If you take a closer look at function source you may see that there's additional call to REPLACE function that replaces double commas with single one:



So, in APEX 4.2 query


will result with
P1_ITEM1,,P1_ITEM2

and in APEX 5
P1_ITEM1,P1_ITEM2

Hope that this will save some debug time to somebody! :)