checking a database link in PL/SQL

Hi,

I have an application that generates data, clients want that data entered into a table on their system via a database link (they don't want to do anything other than give us a valid account to use). If the link is lost the data is to be written to a local copy of the table and copied across when the link is back up (and then deleted from the local table).

I've got a crude PL/SQL trigger that does this ok when the link is up but fails when the link is lost. Is there an elegant way of checking whether a link is good or not?

thanks

Tim Received on Thu Dec 06 2001 - 06:57:11 CST