| ORA-29260: network error: TNS:lost contact [message #220050] |
Sun, 18 February 2007 02:51  |
tareq
Messages: 5
Registered: November 2006
Location: amman
|
Junior Member |
|
|
Hi,
i'm using utl_tcp to open a connection in my code and login to that connection, then i use a loop to wait the message from the client to send the command using oracle pipes, but some times i got the error message ORA-29260: network error: TNS:lost contact, is it a network error, i need to make sure that this is a network error or some other things.
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
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
