Hi Paul, Thanks for that.
Currently having a problem exporting APEX application from the Application Builder. The export wizard is throwing Error exporting flow 111. ORA-06502: PL/SQL: numeric or value error: character string buffer too small, with a ticket logged with Oracle Support on this.
Hence looking at other alternatives to export including command line "APEXExport" tool and SQL Developer to get things moving until I get that resolved (if its possible).
Off topic but have you ever ran into that issue? Someone in the forum ran into it last year as well with same version of APEX as mine APEX 4.2.2.00.11
This might not be related at all but worth checking Denes Kubicek ApEx BLOG: Select List with Dynamic LOV and ORA-06502: PL/SQL: numeric or value error: character string bu…
The other thing I would do is try running the apex advisor to see if it helps.