Hi,
I have a table on which there is a trigger fired after insert.
This trigger opens a socket with another server.
Server, after executing what it has to, closes the client socket
and at the client end (DB side) the whole transaction rolls back saying that
server closed the connection abnormally
which means that the transaction at the DB side ended abnormally and hence
the rollback.
To fix this, i tried closing the client socket at DB end (client side)
itself. Unfortunatel, it keeps running the insert query forever without
accomplishing anything. However, it opens the connection with the server but
doesn't complete its own transaction at all.
Can anyone please help me solving this problem
Thanks,
Jas