-
Hi there,
I'm using utl_tcp to establish a http-communication to webserver. (utl_http does not fit because I need the POST-Method to send XML)
When I open the connection the first time and send data, reading raises utl_tcp.end_of_input, so I close the connection again. Works fine.
Any following attempts using the same procedure (open/write/read/close) raise utl_tcp.network error when trying to read from the open connection.
Rebooting the database resets the status, so I get end_of_input again for one time, then network_error.
Is the utl_tcp.close_all_connections not releasing the connection ? Any Idea ?
thanx in advance
6502
-
What is your environment?
Sam
-
Oracle 8.1.7 on HP.
Communication works now. It was a network problem. My Firewall allowed the connection, but the counterpart firewall dropped it. utl_tcp has no specific exception telling me that the connection was closed by the foreign host. The end_of_input seems to be designed for it, but the package isn't really aware of the connection status.
Using the 'Connection: Keep-Alive' feature of HTTP 1.1 causes my procedure to hang.
The way it works allright is: open, send, read, close for every transaction, using HTTP 1.0 and 'Connection: Close'.
There is one bug in the package, but it can be caught by exception.
Starting my procedure the first time in a session raises
'ORA-29531: No method get_crlf in class oracle/plsql/net/TCPConnection'
'ORA-06512: in "SYS.UTL_TCP', Line 559
6502
