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