Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem fetching data from link server once it is down and then restarted
Hi
When I recompile the stored procedure its works but this also is not a
solution as this is not possible in production.
rajesh.prasad_at_itreya.com (Rajesh) wrote in message news:<1ebcbe13.0211270204.34662272_at_posting.google.com>...
> Hi All,
> I have a stored procedure which select rows from transactional
> database and a remote database (using datbase link)
>
> Example:
> SELECT someId FROM sometable
> UNION
> SELECT someId FROM sometable_at_SOMELINK;
>
> Now, when I stop the Link server and restart it and try to execute the
> stored procedure, I get an error as
> ORA-02068: following severe error from SOMELINK
> ORA-12571: TNS:packet writer failure
>
> I also used views and synonyms but it doesnot help
> can any body help me.
>
> Thanks in advance.
> Rajesh
Received on Wed Nov 27 2002 - 23:23:17 CST