Did you close the link and try and re-open it.
Your stored procedure should trap on this error and reconnect if it occurs.
That session will not automatically reconnect
"Rajesh" <rajesh.prasad_at_itreya.com> wrote in message
news:1ebcbe13.0211272129.6db65614_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.
>
> When I recompile the stored procedure its works but this is also
> not a solution as this is not possible in production.
>
> I am using Oracle 8.1.7.0.0 - Production
> OS : Solaris/W2K (I tried on both).
>
> I will appreciate all the response
> Thanks in advance.
> Rajesh
Received on Sat Nov 30 2002 - 08:41:57 CST
