ORA-01031: insufficient privileges when attempting to SFTP to OIC File server
Summary:
Unable to FTP to OIC SFTP server from ATP Database
Content (required):
I am trying to connect to the OIC SFTP Server from ATP databse, something like below. But getting permission error. Both the ATP database and OIC are on the same cloud instance.
DECLARE
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('<<OIC File server IP>>', '<port number>', 'OIC_USER', 'OIC_password');
ftp.ascii(p_conn => l_conn);
ftp.put(p_conn => l_conn,
p_from_dir => '/UM/Journals/UnProcessed',
p_from_file => 'GlInterface.csv',
p_to_file => '/UM/Journals/Processed');
0