RE: Executing wrong sql
Date: Fri, 31 Oct 2008 14:25:48 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB0675034EFEA8@mds3aex08.USIEXCHANGE.COM>
Make sure that if you are 10.2.0.3 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.
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] 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.
Sandy
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 31 2008 - 13:25:48 CDT