Re: Remote database server problem!

I created the function, works well....but only when a local session is (already) running i.e. I execute a remote procedure, after that I'm shutting down the remote database and then I try again to execute procedure, and then 'your' function triggers...BUT when I close the session after the database was shut down, and then start a new session, and then executing the remote procedure, nothing happens i.e. UI hangs.

Help!

Erwin

Arjan van Bentem wrote:

> 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 Thu Jul 23 1998 - 05:46:26 CDT