oracle12c - PLSQL Oracle SFTP Connection

Question

Is there any way to transfer data through SFTP using oracle PlSql.

I found many exmaples with FTP connnection but no SFTP.

Thank you

question from:https://stackoverflow.com/questions/66047351/plsql-oracle-sftp-connection

Answer 1

You can achieve SFTP operations from PL/SQL with the commercial OraSFTP package. Sample upload operation is like this:

DECLARE 
 connection_id NUMBER; 
 data BLOB;
BEGIN     
 connection_id := ORA_SFTP.CONNECT_HOST('localhost', 22, 'user', 'password');
 
 SELECT blobfield INTO data 
 FROM accounts_payable
 WHERE  account_id = 100;

 ORA_SFTP.UPLOAD(connection_id, data, 'datafile.dat');
 
 ORA_SFTP.DISCONNECT_HOST(connection_id);
END;
/

Disclaimer: I work for DidiSoft