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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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,423 views