FTP pl/sql error
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?