Oracle APEX: File not loading into apex_application_temp_files

2
votes

I have an application in APEX (Oracle Application Express 5.0.0.00.31) and I would like to make the file upload on one page. This is what I currently have:

enter image description here

This is a simple file browser item and a button with action: "Submit page".
My File browser according to new features of APEX 5 should store it's uploaded files (once the page is submitted) in the table apex_application_temp_files and purge them at the end of session, but nothing is ever there.

Can anyone explain what am I doing wrong?

Edit:

This is what I have in the apex_application_temp_files just after the upload:

enter image description here

1
file-uploadoracle-apex
stackoverflow.com/questions/39033701/… ? - Tom
Hi, I tried that and this is not the case, I think I'm doing something wrong with my file browser item because I get the error: No data found. My file is basically never uploaded for some reason - Aleksander Lipka
@Tom to be exact, the debug procedure you provided returns this: "AJAX call returned server error ORA-01403: no data found for Execute PL/SQL Code." - Aleksander Lipka
Why "AJAX call"? Have you put this code in a dynamic action, and not in an on-submit process? - Tom
Okay: so just do the loop over the table and view the debug. Are there liens in there (there should be). Also, keep in mind that selecting on the view from sql developer may simply not work because of built-in restrictions in those views and which may only work within an active apex session! Furthermore, it helps when you just share your code (if there's any). Just uploading the file and then checking in an sql-dev session is not correct. - Tom

1 Answers

2
votes

As suggested here: issue with apex_application_temp_files

Use some debug as a sanity check.

Don't try to query the view from sqldeveloper, it won't give you the results you require as it won't work without some contexts set (or without a session). Since sqldev. This is why at first looping over the files in the view helps you most, and just crossref it with the value from the file-item. You can then set up the select into statement, debug that, and if working go from there.