Re: problem with view with link

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Mon, 20 Oct 2003 18:12:30 GMT
Message-ID: <iAVkb.7872$Fc5.4738@nwrdny01.gnilink.net>

"cf" <news_at_tolede.com> wrote in message
news:3f941297$0$241$4d4eb98e_at_read.news.fr.uu.net...
> Hi
> First execuse me for my poor english.
>
> I have a view
> Create view vw_sample as
> select * from sample
> union all
> select * from sample_at_link1
> /
>
> I would like just return select * from sample where the link faild.
> because i have an ora-02068 or ora-02051 or ora-02063 when the link is
> faild. (netwook down)
>
> Thanks in advances.
> Christophe.
>
>

I don't know of a way to do this via SQL alone. However, if you are using PL/SQL .. then
you would just need to write an exception handler to handle this thing.

You did not state your Oracle version ... Even with SQL, maybe using pipelined functions might be one way to do this (sorry I don't
have time to test this).

Anurag Received on Mon Oct 20 2003 - 13:12:30 CDT