question: program for ora 02068 error

oracle , dblink , ora02068 error , program interrupt , exception El Monte, United States
  • 9 years ago

    How to program around ora-02068 error

    On DB2 side, newbie to oracle platform. . .HELP !!

    Oracle procedure, db link to DB2, gets 02068 rpc disconnect errors inconsistently/randomly. No error messages, no contention, and response time on both platforms are OK.

    procedure:

    1. select....
    2. commit.
    3. execute immediate...alter session...close dblink...
    4. exception

    We think it is getting stuck between 1 and 2 above, problems in communications, just hanging so exceptions do not catch errors. Theory is the next invoke generates the error message when it tries to reuse the hanging link, before it starts a new one. (?)

    Question: How can we program a band-aid to check the elapsed response time, interrupt and return control after 10 elapsed seconds, so we can retry and/or terminate cleanly as appropriate ??

    Thanks.

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“A computer is a stupid machine with the ability to do incredibly smart things, while computer programmers are smart people with the ability to do incredibly stupid things. They are, in short, a perfect match” - Bill Bryson