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

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

Re: problem with view and link

From: cf <news_at_tolede.com>
Date: Tue, 21 Oct 2003 15:18:10 +0200
Message-ID: <3f953219$0$244$4d4eb98e@read.news.fr.uu.net>


thanks a lot

"Daniel Morgan" <damorgan_at_x.washington.edu> a écrit dans le message de news:1066675290.265665_at_yasure...
> cf wrote:
>
> >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.
> >
> >
> BEGIN
> SELECT COUNT(*)
> INTO i
> FROM dual_at_link1;
>
> <query local and remote>
> EXCEPTION
> WHEN OTHERS THEN
> <query only local>
> END;
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
> http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
Received on Tue Oct 21 2003 - 08:18:10 CDT

Original text of this message

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