0 Replies Latest reply: Feb 18, 2007 2:54 AM by 318551 RSS

    ORA-29260: network error: TNS:lost contact

    318551
      hi experts,

      I'm using utl_tcp in my code to open a connection and to enter a username and password, i put a loop in my code to receive the command from the client using oracle pipes, some time i got the error ORA-29260: network error: TNS:lost contact, and some times the command sent to the server throw the connection and i got a successful response,thank you.

      part of the code

      .....
      c := UTL_TCP.open_connection (remote_host=> Pipaddress,
      remote_port=> Pportnumber,
      CHARSET => 'US7ASCII');

      -- login
      ret_val := UTL_TCP.write_line (c,'LOGIN:' || Puser|| ',' || Ppass|| ';');
      .........
      LOOP
      .........
      RESULT := DBMS_PIPE.RECEIVE_MESSAGE (p_name);
      DBMS_PIPE.UNPACK_MESSAGE (his_msg_cmd);
      DBMS_PIPE.UNPACK_MESSAGE (his_msg_params);
      .........
      ret_val := UTL_TCP.write_line (c, his_msg_cmd || ':' || his_msg_params || ';');
      .........
      END LOOP;
      .........
      ret_val := UTL_TCP.write_line (c, 'LOGOUT:;');
      UTL_TCP.close_connection (c);
      ........
      END;

      regards
      tareq

      Message was edited by:
      tareq1230