Ora-29260 Network Error Tns
Contents |
- 8:35 am UTC Category: Database � Version: 8.1.6 Whilst you are here, check out some content from the AskTom team: On Uniqueness, Space, and Numbers Latest Followup You Asked Tom: I have written a Java ora-29260: network error: tns:operation timed out Stored Procedure but what it does is to open a socket and send a ora-29260 network error not connected msg to an external server. I have asked about this issue in the past and you suggested to use utl_tcp package.
Ora-29260: Network Error: Tns:connection Closed
Do you have samples how to use this? I have a stored procedure to create an record in the database and at the end of that process I want to open a socket and
Ora-29260 Utl_tcp
send two msgs to the external process ( I know the ip address and the port number of that process ), my first msg is a an authentication msg ( if the id/password is wrong then the server will close the socket ) and if the authentication is successful then I will send another msg with some data to the server. If you can help me with a sample how ora 29260 network error tns lost contact to use the utl_tcp pacjage that will be a great help. TIA Reji and we said... Here is a really small example doing what you ask, I make a web request but the concept is the same. tkyte@THINK1.US.ORACLE.COM> DECLARE 2 c utl_tcp.connection; -- TCP/IP connection to the Web server 3 n number; 4 BEGIN 5 c := utl_tcp.open_connection('aria.us.oracle.com', 80); -- open connection 6 n := utl_tcp.write_line(c, 'GET / HTTP/1.0'); 7 n := utl_tcp.write_line(c); 8 BEGIN 9 LOOP 10 dbms_output.put_line( utl_tcp.get_line(c, TRUE)); -- read result 11 END LOOP; 12 EXCEPTION 13 WHEN utl_tcp.end_of_input THEN 14 NULL; -- end of input 15 END; 16 utl_tcp.close_connection(c); 17 END; 18 / HTTP/1.0 200 OK Date: Wed, 05 Jul 2000 17:20:57 GMT Allow: GET, HEAD Server: Oracle_Web_listener2.1/1.20in2 Content-Length: 299 Content-Type: text/html Last-Modified: Wed, 10 Nov 1999 22:38:02 GMT URI: