We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
6
Views
1
Comments
edited Jun 15, 2020 6:19AM in Database 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!