got triggers? On 10/10/08, Sandra Becker <sbecker6925@xxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l