Connect to remote ftp.

Examples

Ex. 1. Open an FTP Connection.
Ex. 2. Open an FTP Connection specifying port number.

SET SERVEROUTPUT ON SIZE 1000000;
DECLARE
  fid VARCHAR2(80);
  host VARCHAR2(80)   := 'ftp.gnu.org';
  usernm VARCHAR2(80) := 'anonymous';
  passwd VARCHAR2(80) := '';
BEGIN
  fid := fclient_p.createFTPClient;

  fclient_p.conn(fid, host);

  fclient_p.username(fid, usernm);
  fclient_p.password(fid, passwd);
  fclient_p.logout(fid);
  fclient_p.remove(fid);
EXCEPTION
  WHEN fclient_p.java_failed THEN
    DBMS_OUTPUT.PUT_LINE(SUBSTR(fclient_p.getErrorWithResponse(fid), 1, 255));
END;
/

SET SERVEROUTPUT ON SIZE 1000000;
DECLARE
  fid VARCHAR2(80);
  host VARCHAR2(80)   := 'ftp.gnu.org';
  usernm VARCHAR2(80) := 'anonymous';
  passwd VARCHAR2(80) := '';
BEGIN
  fid := fclient_p.createFTPClient;

  fclient_p.conn(fid, host, fclient_p.getDEFAULT_PORT);

  fclient_p.username(fid, usernm);
  fclient_p.password(fid, passwd);
  fclient_p.logout(fid);
  fclient_p.remove(fid);
EXCEPTION
  WHEN fclient_p.java_failed THEN
    DBMS_OUTPUT.PUT_LINE(SUBSTR(fclient_p.getErrorWithResponse(fid), 1, 255));
END;
/

If you need to check if conn is successful add the following snippet of code immediately after
the call to conn:

  IF fclient_p.getLastResponseReturnCode(fid) = '220' THEN
    DBMS_OUTPUT.PUT_LINE('Successful');
  ELSE
    DBMS_OUTPUT.PUT_LINE(SUBSTR('Failed, Reason :'||REPLACE(fclient_p.getLastResponse(fid), CHR(10)), 1, 255));
  END IF;