Re: problem with view and link

conn system/@db1

select count(*) from dual_at_db2
/
COUNT(*)

        1

When the netwook broken the same request return ORA-02051 and ORA-02063

When then netwook up, i have the same errors.

But in an others session, the request is good.

Thanks in advances.
Christophe.

"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:42:59 CDT