Hi all,
Using the Oracle "Sample Data loading" App as reference, I am trying to create an APEX page for users to upload an XLSX into a table.
(APEX 20.2.0.00.20, Oracle Database 11g Enterprise 11.2.0.4.0 - 64bit - PL/SQL Release 11.2.0.4.0)
The sample app uses the parser in a SELECT statement as source in a classic report.
I am using this same SELECT source with an insert statement in a on submit process but results in no data inserted. It can parse for the Classic report but it can't insert? What am I missing?
So,
File Browser page item -> Select XLSX file
Click the UPLOAD FILE button which submits the page (as existed for the classic report)
Runs an Execute Code Process with the Insert statement.
I've confirmed that the process does run on submit, but No data is inserted.
Thanks