RE: Executing wrong sql

From: Bort, Guillermo <>
Date: Fri, 10 Oct 2008 11:38:26 -0500
Message-ID: <>

I have seen a database returning the wrong values to an application when using cursor sharing on force. What's the value of CURSOR_SHARING on this database?  

I think that the code would help but I understand that you can't usually publish copyrighted code.  

Guillermo Alan Bort

DBA / DBA Main Team  

EDS, an HP company

ITO Arias 1851

Ciudad Autonoma de Buenos Aires (C1429DXC)


Tel: +54 11 4704-3132

E-mail: <>  

We deliver on our commitments

so you can deliver on yours.  

[] On Behalf Of Sandra Becker Sent: Friday, October 10, 2008 1:11 PM
To: oracle-l
Subject: Executing wrong sql  

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, SuSE10, IBM z9 VM  

Any suggestions will be appreciated.  


Received on Fri Oct 10 2008 - 11:38:26 CDT

Original text of this message