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!

Load data to Oracle Apex Database externally

Dylan GonzalezJul 22 2024

I have an app built through Oracle APEX and also have an external application (website) that users also use, and it uses the same database (I have set up the REST API on Oracle Database Actions). Currently to import a user's inventory I have to get their csv and then manually load it through the data load utility in APEX. Is there any way for me to automate this import where the customer can upload the csv and expect the data to insert? I have done this in the past with other databases but I believe Oracle does not allow external connections to their underlying database. For example how can I have my websites REST API make those insert statements into the underlying APEX database instance?

Comments
Post Details
Added on Jul 22 2024
1 comment
344 views