Re: problem with view and link

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)