RE: Executing wrong sql
- From: "Bort, Guillermo" <guillermo.bort@xxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Oct 2008 11:38:26 -0500
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)
Argentina
Tel: +54 11 4704-3132
E-mail: guillermo.bort@xxxxxxx <mailto:name.name@xxxxxxx>
We deliver on our commitments
so you can deliver on yours.
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 10.2.0.3, SuSE10, IBM z9 VM
Any suggestions will be appreciated.
Sandy
Other related posts:
