Re: Remote database server problem!

I use a local function like:

  create or replace function TestConnection return boolean as     v_Dummy date;
  begin
    select sysdate
    into v_Dummy
    from dual_at_my_dblink;
    return true;
  exception
    when others
      return false;
  end TestConnection;

Note that this functions returns your local sysdate, not the sysdate of the remote database. However, it uses dual_at_my_dblink, which surely forces a connection to the remote database to be made.

Arjan. Received on Wed Jul 22 1998 - 13:40:59 CDT