Did you try "create or replace synonym " instead of dropping it and =
recreating it?
Waleed
-- --Original Message-- --
From: ryan.gaffuri@(protected) [mailto:ryan.gaffuri@(protected)]
Sent: Friday, May 14, 2004 2:08 PM
To: oracle-l@(protected)
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 (See ORA-00600.ora-code.com) =
error that is only logged in metalink two times.
Also, the ORA-600 (See ORA-600.ora-code.com) 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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------
To unsubscribe send email to: oracle-l-request@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
