Hello,
I've developed an application with Application Express 5.0.0.00.31, with a number of "File Chooser" to allow users to load data to the database.
The files are stored in APEX_APPLICATION_TEMP_FILES then parsed by specific PL/SQL procedure, like below:
BEGIN
:P1_MESSAGE := #OWNER#.APEX_PKG_MY_APP.FILE_LOAD(:P1_FC_LOAD_FILE);
END;
Where "P1_FC_LOAD_FILE" is the name of the file chooser item.
This works find in the development environment on an Oracle Database version 12c.
I migrated the application to a test environment with a runtime APEX installation, by exporting the workspace then the application, then importing them with SQL*PLUS on the new environment. The database version is 11g.
In the test environment, the files are not stored in APEX_APPLICATION_TEMP_FILES: the application behaves like "P1_FC_LOAD_FILE" had not been set by the user.
The "nohup.out" log file shows that an error "ORA-00942: table or view does not exist" is raised by the oracle.dbtools.apex.FileUpload.loadFile .
I tried to change the grants on FLOWS_FIELS.WWV_FLOW_FILE_OBJECTS$, the table on which APEX_APPLICATION_TEMP_FILES is based, but it didn't solve the problem.
Thank you in advance.