Oracle Database Requirements: Oracle Application Express release 5.0 requires an Oracle Database Release 11.1.0.7 or later, including Enterprise Edition and Express Edition (Oracle Database XE). If you are upgrading an Oracle Database version 12c CDB, you must download from My Oracle Support the one off patch for bug 20618595. Search for 20618595 on the Patches tab.
Memory Requirements: Oracle Application Express requires the system global area (SGA) and program global area (PGA) to be at least 300 MB. Databases typically use automatic memory management, where the memory can be controlled by the server parameter MEMORY_TARGET. If your database does not use automatic memory management, consult the Oracle Database Administrator’s Guide to find out how to configure manual memory parameters (for example, SGA_TARGET, PGA_AGGREGATE_TARGET, SHARED_POOL_SIZE) instead, for a similar result.
Substitution Strings
Variables in APEX -V / NV FunctionsIf you want to reference APEX variables in compiled code, such as views, packages, and procedures, you can’t use bind variables. The easiest way to reference the variables is to use the V (for strings) and NV (for numbers) functions.