Re: check on the status of a remote database

The following is a basic procedure which provides a basic check..it may be enough for you.....

create or replace procedure test_remote_db_up as

dummy varchar2(1);

begin

  begin
    select 'x'
    into dummy
    from dual_at_remote_db;

    dbms_output.put_line('can access the remote database');

  exception

      when others then
         dbms_output.put_line('cannot access the remote database');

end;
/

Hope this helps

Steve Bright

steve.bright_at_capgemini.co.uk

ejs2nd_at_my-deja.com wrote in message <7mo9mm$s6r$1_at_nnrp1.deja.com>...
>Is there a way to check whether a remote DB is
>down in a PL/SQL script?
>
>Here's the situation:
>
>I'm using PL/SQL to generate an intranet site that
>pulls info from a remote database. Today, that
>remote DB went down, and the whole site crashed.
>
>I'd like to insert a check on the status of the
>remote DB in the code, and if the DB is down, I
>can redirect to a page that doesn't display
>anything from the remote DB.
>
>Any suggestions would be appreciated.
>Ed
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Sat Jul 17 1999 - 15:25:54 CDT