Get-Put file from Oracle Directory about as_sftp HOT 3 CLOSED

You mean read a file from a Oracle directory into a blob, which you can transfer to a SFTP server using this package?
declare
l_bfile bfile;
l_blob blob;
l_dest_offset integer := 1;
l_src_offset integer := 1;
begin
as_sftp.open_connection( i_host => 'localhost' );
as_sftp.login( i_user => 'demo', i_password => 'demo' );
dbms_lob.createtempoorary( l_blob, true );
l_bfile := bfilename( 'MY_DIR', 'test.txt' );
dbms_lob.fileopen( l_bfile, dbms_lob.file_readonly );
dbms_lob.loadblobfromfile
( dest_lob => l_blob
, src_bfile => l_bfile
, amount => dbms_lob.lobmaxsize
, dest_offset => l_dest_offset
, src_offset => l_src_offset
);
as_sftp.put_file( i_path => 'test.txt', i_file => l_blob );
dbms_lob.freetemporary( l_blob );
dbms_lob.fileclose(l_bfile);
as_sftp.close_connection;
end;

from as_sftp.

@antonscheffer Yes, that's the one I try to do so long time ago
Now I use your sample script to put file on sFTP and it's work! But I still can't get file from sFTP to my directory. Can you suggest me more?

from as_sftp.

Use google, for instance https://oracle-base.com/articles/9i/export-blob-9i

from as_sftp.