Re: Executing wrong sql

From: Rumpi Gravenstein <rgravens_at_gmail.com>
Date: Fri, 10 Oct 2008 17:16:56 -0400
Message-ID: <9c9b9dc90810101416r31d8d53cta0e758b39a7e80d8@mail.gmail.com>


got triggers?

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.
>
> Sandy
>

-- 
Rumpi Gravenstein
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 10 2008 - 16:16:56 CDT

Original text of this message