I raise my problem, I need if it is possible to catch an exception and prevent it from reversing or cancel my insertion or update so that the local data is saved if or if.
When I insert a record in table1 I have to trigger a procedure to insert it in other databases, but if any of these insertions in the procedure fails I do not want my insertion to be reversed in table1, but save the sql statement of the databases that failed to be able to execute them later.
I have no idea if this is possible and I can not find the right words to find it.
on insert trigger
try
procedimiento de insercion en base externa
on exception
insertar en tabla para ejecutar mas tarde
end
end