How to get files from external SFTP in Oracle APEX hosted in cloud.
SummaryGetting the files from SFTP and store it in APEX DB tables.
The requirement was get the files from external SFTP and store it in the BLOB Column of a table.
Please suggest any work around for this issue.
I am using Free cloud instance provided by apex.oracle.com
DECLARE l_conn UTL_TCP.connection; BEGIN l_conn := ftp.login('ftp.company.com', '21', 'ftpuser', 'ftppassword'); ftp.ascii(p_conn => l_conn); ftp.logout(l_conn); END; /