How check remote connection in oracle
840183Mar 15 2011 — edited Mar 15 2011Hi Expert,
I working on data transferring from one database server to another database server.
but at starting i want to check weather remote database is connected or not?
could anyone help me for that?
for e.g.
a := get_remote_connection; --- Calling function for check remote connection return boolean
if a then
<call my data_transfer_proc>
else
exit;
end if;
reply.