-
1 Attachment(s)
Ora-00604:
hi ,
when i run the proc the get the below error and the code is written by someone else.I am not able to trace ....
SQL> DECLARE
2 l_conn UTL_TCP.connection;
3 BEGIN
4 l_conn := ftp.login('chennai.satyam.com', '21', 'lfo', 'lfoUser1');
5
6 dbms_output.put_line('test1');
7
8 ftp.ascii(p_conn => l_conn);
9
10 ftp.put(p_conn => l_conn,
11 p_from_dir => '/usr/gbom/sionsitetesting/vehiclecode',
12 p_from_file => 'vehicle_code.csv',
13 p_to_file => '/lfo/sionsitetesting/vehiclecode');
14
15 dbms_output.put_line('test2');
16 ftp.logout(l_conn);
17 utl_tcp.close_all_connections;
18 dbms_output.put_line('test3');
19 END;
20 /
DECLARE
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-01460: unimplemented or unreasonable conversion requested
ORA-06512: at "SYS.DBMS_LOB", line 504
ORA-06512: at "LFO.FTP", line 122
ORA-06512: at "LFO.FTP", line 347
ORA-06512: at line 10
thanks in advance.:o :o :o
-
You need to look at lines 122 and 347 of the "LFO.FTP" package "PUT" procedure. :rolleyes: