Hi,
I have a local table A and a federated table B.
I'm trying to insert into federated table B using After trigger Insert on local table A.
Everything works as long as both servers are connected.
Whenever the other server is either down or unavailable during insert action it gets hung or something. I'm not sure whether it is waiting for the server. It gets hung and as long as i reconnect back to other server the action resumes.

I would like to throw an error and keep going.
I tried RESIGNAL as below
DECLARE EXIT HANDLER FOR SQLEXCEPTION
RESIGNAL;
But doesn't seem to help. Any ideas?

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.