Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: problem with view with link
Thanks a lot to Daniel Morgan (response in comp.databases.oracle.misc)
BEGIN
SELECT COUNT(*)
INTO i
FROM dual_at_link1;
<query local and remote>
EXCEPTION
WHEN OTHERS THEN
<query only local>
END;
"cf" <news_at_tolede.com> a écrit dans le message de
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.
>
>
Received on Tue Oct 21 2003 - 08:24:07 CDT