title: How to read .csv file from FTP or SFTP server using Oracle PL SQL?
body: <p>I want to read data of .csv file which is located at FTP or SFTP server using Oracle SQL or PL SQL.
      I tried the below code and it showing output like SSH-2.0-OpenSSH_5.3 that means connected i hope.</p>
  
  <pre><code> declare
    c  utl_tcp.connection;  -- TCP/IP connection to the Web server
    ret_val pls_integer;
  BEGIN
    c := utl_tcp.open_connection(remote_host =&gt; 'ftp.******.******.com'
                                ,remote_port =&gt;  21
                                ,charset =&gt; 'US7ASCII'
  --                              ,wallet_path     =&gt; '****************'
  --                              ,wallet_password =&gt; '**********'
                                );  -- open connection
  --  ret_val := utl_tcp.write_line(c, 'GET / HTTP/1.0');    -- send HTTP request
    ret_val := utl_tcp.write_line(c);
    BEGIN
      LOOP
        dbms_output.put_line(utl_tcp.get_line(c, TRUE));  -- read result
      END LOOP;
    EXCEPTION
      WHEN utl_tcp.end_of_input THEN
        NULL; -- end of input
    END;
    utl_tcp.close_connection(c);
  END;
  /
  </code></pre>
  
  <p>Could someone help me on next steps on How to open and read  the .csv file present in SFTP/FTP server and load it into Oracle DB table ?</p>