question: program for ora 02068 error

• • Reply

  11 years ago

  by vquanski

  von quan

  Los Angeles, United States

  Joined 11 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.

  Report abuse