Client side exception handling interfers with Oracle errorhandling?

From: <ryan.gaffuri_at_cox.net>
Date: Fri, 14 May 2004 14:07:54 -0400
Message-Id: <20040514180753.OLNI7895.lakermmtao10.cox.net@smtp.east.cox.net>

I have an odd TAR open with Oracle support. It will take a bit for me to set it up. Please let me know if you have run across it.

USER A owns Table A
USER B owns Table A

So we have two copies of the table. Same structure, different data. The synonym points to user A.

Our application uses the the table owned by user A, without a problem, we then drop the synonym and point it to USER B. We get an ORA-00600 error that is only logged in metalink two times.

Also, the ORA-600 error is not getting written to the alert log or generating a trace. We know about it, because our client(IIS, .Net middle tier) has exception handling that traps all errors, then writes the error, time stamp, and SQL to a table.

Oracle says this might be trapping the error before Oracle has a chance to pick it up. I cannot re-create with SQLPlus.

Anyone ever run into this? Sounds odd.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sat May 15 2004 - 11:34:38 CDT