Re: How to Check whether Server is up in Oracle Stored Procedure

Srini wrote:

> We have a Oracle client where a trigger is present. A Stored procedure
> is associated with the trigger. And link between Oracle client and
> server is using DBLINK.
>
> When Oracle server machine is down or database server has crashed, we
> want the stored procedure not to be executed. The problem is we do not
> always come to know when the server machine is down ( for say,
> maintenance ).
>
> Can any one tell me how we can code this check (on the server) inside
> the Stored Procedure ?
>
> Regards,
> Srini

You can't. Triggers are on servers not clients. Further ... db links are not between client and server but rather between server and server. So please rewrite your question clearly defining the issue and stating your version of Oracle.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)