Re: Executing wrong sql
Date: Fri, 10 Oct 2008 17:16:56 -0400
On 10/10/08, Sandra Becker <sbecker6925_at_gmail.com> wrote:
> I have a developer trying to run an SQL script against a test database that
> is picking up the wrong sql instead of what is really in my PL/SQL script.
> What's really strange to me is that if I set echo on, I can see the code it
> should be executing, not what it is really executing. Could this be due to
> a cursor left open? I've never seen this behavior before so I'm a bit lost
> on where to look.
> If I run the same script against another test database, it works like it's
> supposed to. The developer also tells me that this code worked on this
> database until we bounced it yesterday.
> Our environment for both databases: Oracle 10.2.0.3, SuSE10, IBM z9 VM
> Any suggestions will be appreciated.
-- Rumpi Gravenstein -- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 10 2008 - 16:16:56 CDT