Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: problem with view with link

Re: problem with view with link

From: cf <news_at_tolede.com>
Date: Tue, 21 Oct 2003 15:24:07 +0200
Message-ID: <3f953379$0$237$4d4eb98e@read.news.fr.uu.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US