RE: Executing wrong sql

From: Crisler, Jon <>
Date: Fri, 31 Oct 2008 14:25:48 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675034EFEA8@mds3aex08.USIEXCHANGE.COM>

Make sure that if you are that you have installed patch 5863277. This issue is found on most Unix platforms, but I don't know if it also applies to Windows.  

If you have the same table present in multiple schemas, and execute the same sql cached in the pool, it may run against the wrong schema.  

[] On Behalf Of Sandra Becker Sent: Monday, October 13, 2008 3:13 PM
To: oracle-l
Subject: Re: Executing wrong sql  

We bounced the database and kept everyone out while we ran the PL/SQL script in question. I had a trace on the session running the script. It worked like we wanted it to, picking up the correct sql. Still don't know why we couldn't get it to change and use the new code though.  

Thanks for all your help.  


Received on Fri Oct 31 2008 - 13:25:48 CDT

Original text of this message