On 4/26/05, Niall Litchfield <niall.litchfield@(protected):
> Would a quick hack to code the procedure as a version of
> l_alive number;
> select 1 into l_alive from dual@(protected);
> if l_alive =3D 1 then
> end if
> make sense?
> This might avoid ocella upgrades breaking your check, or dealing with
> the politics :).
Yes, that looks like it will do the job nicely.
> Alternatively you might wish to add error handling for what ever
> errors you get when the ocella db is down and add that to your
> functions and procedures...
Unfortunately the app just fires dynamic SQL directly at the database,
no functions or procedures involved. I'm told by the consultants that
they can add some code to call a function and check the result. I
suspect packaging that block up in a function that returns TRUE if it
works and adding an exception handler for the ORA-03113
returns FALSE would do quite nicely.
It's better to ask a silly question than to make a silly assumption.