This content has been marked as final. Show 7 replies
995627 wrote:which ever port you specify
LINUX 6.4 64BIT
When we use UTL_TCP to connect to a remote host from server_abc or server_xyz, do you know what local port(s) on the server_abc/server_xyz server is used to make the connection?
TYPE connection IS RECORD ( remote_host VARCHAR2(255), remote_port PLS_INTEGER, local_host VARCHAR2(255), local_port PLS_INTEGER, charset VARCHAR2(30), newline VARCHAR2(2), tx_timeout PLS_INTEGER, private_sd PLS_INTEGER);
my car won't go.
tell me how to make my car go.
since we don't know exactly what you do, we can't say what you do wrong.
Do you have error of commission or error of omission?
How do I ask a question on the forums?
SQL and PL/SQL FAQ
what problem are you REALLY trying to solve?
995627 wrote:The last message in the error stack (typically the root cause) says that your TCP client connection attempted to connect to a target (IP address and TCP port) that is not accepting TCP client requests.
i got that error
ORA-29260: network error: not connected
ORA-06512: at "SYS.UTL_TCP", line 231
ORA-06512: at "SYS.UTL_TCP", line 460
ORA-06512: at "TGPLDBA.UTIL_HTTP", line 411
ORA-29260: network error: TNS:no listener
This can be because the remote server is not running the service on the server port your code attempts to connect to. This can be because of a firewall issue.