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!

FTP pl/sql error

user15074Dec 12 2008 — edited Dec 17 2008
Create procedure and execute,i want to put file from C:\Inetpub\ftproot\dawn\test.txt into C:\Inetpub\ftproot.

CREATE OR REPLACE PROCEDURE FTPTEST
AS
l_conn UTL_TCP.connection;
BEGIN
l_conn := ftp.login('pc', 'port', 'user', 'password');
ftp.binary(p_conn => l_conn);
ftp.get(p_conn => l_conn,
p_from_file => 'C:\Inetpub\ftproot\dawn\test.txt',
p_to_dir => 'C:\Inetpub\ftproot',
p_to_file => 'test1.txt');
ftp.logout(l_conn);
utl_tcp.close_all_connections;
END;
/

SQL> execute FTPTEST;
BEGIN FTPTEST; END;

*
ERROR at line 1:
ORA-29281: invalid mode
ORA-06512: at "ADT_OWN.FTP", line 352
ORA-06512: at "ADT_OWN.FTP", line 442
ORA-06512: at "ADT_OWN.FTPTEST", line 9
ORA-06512: at line 1

Anybody have any ideas?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2009
Added on Dec 12 2008
14 comments
733 views