OraSFTP – SFTP for Oracle PL/SQL

Send and Receive files from SFTP servers directly from your Oracle PL/SQL code

DECLARE 
  connection_id NUMBER;  
  private_key BLOB;  
  private_key_password VARCHAR2(500);  
  username VARCHAR2(500);  
  hostname VARCHAR2(500);
BEGIN
    ...
    hostname := 'localhost';
    username := 'didisoft';
    connection_id := ORA_SFTP.CONNECT_HOST(hostname, username, private_key, private_key_password);
 
    ORA_SFTP.UPLOAD(connection_id, blob_data, 'data.dat');    
    ORA_SFTP.DISCONNECT_HOST(connection_id);
END;

Didisoft OraSFTPDidiSoft OraSFTP is a PL/SQL package (ORA_SFTP) providing SFTP client side communication functionality for the Oracle (c) Database platform version 11 and 12.

Current version 1.2.12
Build date 12 March 2019

Supported Oracle Database platforms:
Enterprise Edition (version 11+)
Standard Edition (version 11+)
Standard One (version 11+)

Functionality in brief
The package provides Oracle PL/SQL functions for SFTP client side communication. The standard SFTP functionality upload, download, list files, manage remote directories, etc., are available. Supports PuTTY, OpenSSH and ssh.com type of keys with algorithms RSA, DSA, ECDSA.

Licensing
The product is licensed per server or for a whole Enterprise (unlimited number of servers)

Trial version limitations
30 days evaluation copy

Additional documentation