i want to update data on remote server. So, i do follwing
- create database link
- create trigger on a table
insert, update and delete data
it is working fine when i insert, update and delete data on server a it changes same on server b.
now i want to check connection in trigger, if connection established then insert,update and delete on remote server otherwise insert in a log table.
help me how to check connection weather is established or not