Skip to Main Content

SQL & PL/SQL

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.

How can I get data file from FTP server in Apex?

Punk WFeb 13 2025

We have a file that we want to get and store the data in one of the tables in oracle apex in the OCI. I understand that there are two ways to do this, please correct me if i am wrong: PS/SQL using UTL_TCP and UTL_FILE packages or Oracle Integration using FTP Adapter. My understanding it that the FTP Adapter is a recurring cost if we keep using it to transfer data, and that is what we intend to do as we need to update this data daily. So because of this I do not see this as a viable solution. So that leaves me with the PS/SQL. But there just isn't enough information out there. The one I found is more then 10 years old. Can someone lead me down the right path to achieve this? FYI I am new to Oracle Apex. Thanks.

Comments
Post Details
Added on Feb 13 2025
3 comments
111 views