When processing a background execution chain, File Browse items cannot be used directly as we normally can.
If I set ‘Temporary File Handling’ to Move and ‘Temporary File Items’ left blank:
For original session file appears in APEX_APPLICATION_TEMP_FILES but not in the cloned session used by the execution chain. Confirmed by using apex_debug.message to loop through a select statement and print found rows (there is none). No errors displayed (even though pl/sql execution fails with ‘no data found’).
If I set ‘Temporary File Handling’ to Copy and ‘Temporary File Items’ left blank:
ORA-06533: Subscript beyond count
This appears very early on so cannot confirm if files appear in APEX_APPLICATION_TEMP_FILES.
