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:
- select....
- commit.
- execute immediate...alter session...close dblink...
- 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.
!--removed tag-->
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).