Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 23.1 Background Execution Chain - File Upload not working, APEX_APPLICATION_TEMP_FILES 'no data found'.

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.

This post has been answered by Carsten Czarski-Oracle on Jul 21 2023
Jump to Answer
Comments
Post Details
Added on Jul 20 2023
4 comments
1,496 views