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

Thread: Ora-00604:

  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

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,483

    Cool

    You need to look at lines 122 and 347 of the "LFO.FTP" package "PUT" procedure.
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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