Workflow parameters and page items in APEX support:
B . NUMBER: For numeric values (e.g., 123.45), used in calculations or IDs.
C . CLOB: For large text (e.g., descriptions), stored as character large objects.
D . VARCHAR: For variable-length strings (e.g., EMPLOYEE_NAME), capped at 4000 characters in most
cases.
A . Image: Not a supported data type for parameters or items; images are handled as BLOBs or file
uploads, not directly as a Workflow parameter type.
These types align with Oracle Database, ensuring robust data handling in workflows.
Reference: Oracle APEX 23.2 Documentation - "Workflow Parameters" under Workflow Features.
