Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Regarding FTP

FahedAkhterOct 28 2008 — edited Oct 29 2008
I want to download the latest update of Symantec Antivirus daily. For that I use Ftp. The steps which I followed is as under

1) CREATE OR REPLACE DIRECTORY "my_docs" AS 'E:\Vrupdate\' ;

2) -- Retrieve a binary file from a remote FTP server.

DECLARE
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('ftp.symantec.com', '21', 'guest','guest');
ftp.binary(p_conn => l_conn);
ftp.get(p_conn => l_conn,
p_from_file => '/AVDEFS/symantec_antivirus_corp/20081027-003-x86.exe',
p_to_dir => 'MY_DOCS',
p_to_file => 'update.exe');
ftp.logout(l_conn);
utl_tcp.close_all_connections;
END;

But it gives me error which is mention below

220 spftp/1.0.0000 Server [64.86.106.103]
331 Password required for USER.
230-
230- ---------------------------------------------------------------------------
230- WARNING: This is a restricted access system. If you do not have explicit
230- permission to access this system, please disconnect immediately!
230 ----------------------------------------------------------------------------
200 TYPE set to I.
227 Entering Passive Mode. (64,86,106,103,232,1)
150 Opening BINARY mode data connection for /AVDEFS/symantec_antivirus_corp/20081027-003-x86.exe (37113664 bytes).
226 Transfer Complete
ORA-29281: invalid MODE
ORA-06512: at "OAS.FTP", line 358
ORA-06512: at "OAS.FTP", line 451
ORA-06512: at line 7

Please Advice.

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2008
Added on Oct 28 2008
9 comments
469 views