How to get files from external SFTP in Oracle APEX hosted in cloud.

Summary

Getting the files from SFTP and store it in APEX DB tables.

Content

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

Version

20.1

Code Snippet

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;
/