| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Client side exception handling interfers with Oracle errorhandling?
Did you try "create or replace synonym" instead of dropping it and =
recreating it?
Waleed
-----Original Message-----
From: ryan.gaffuri_at_cox.net [mailto:ryan.gaffuri_at_cox.net]
Sent: Friday, May 14, 2004 2:08 PM
To: oracle-l_at_freelists.org
Subject: Client side exception handling interfers with Oracle
errorhandling?
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.=20
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.=20
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |