DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-00604:

Threaded View

  1. #1
    Join Date
    Sep 2003
    Location
    india
    Posts
    23

    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.
    Attached Files Attached Files
    ramya

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width