RE: Executing wrong sql

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: sbecker6925@xxxxxxxxx
  • Date: Fri, 10 Oct 2008 13:30:02 -0400

What's issuing the code?  I have seen cases in which, for example,
Microsoft client-side development environments make changes to SQL
before submitting to the database.
 

Paul Baumgartel 
CREDIT SUISSE 
Information Technology 
Prime Services Databases Americas 
One Madison Avenue 
New York, NY 10010 
USA 
Phone 212.538.1143 
paul.baumgartel@xxxxxxxxxxxxxxxxx 
www.credit-suisse.com 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sandra Becker
Sent: Friday, October 10, 2008 1:13 PM
To: guillermo.bort@xxxxxxx
Cc: oracle-l
Subject: Re: Executing wrong sql


CURSOR_SHARING is set to EXACT.
 
Here is a sanitized version of the section of code we're having problems
with:
 
.
.
.
               DECLARE
                    CURSOR pvi1 IS
                    SELECT DISTINCT mi.docid, mi.invnumber,
mi.datereceived
                    FROM invpayment ip, mbinv mi
                    WHERE ip.invnumber = mi.invnumber
                      AND mi.boid = incoid
                      AND substr(mi.soid, 0, 12) =
substr(vndr.partnerid, 0, 12)
                      AND mi.ISDELETED != '1'
                      AND mi.state = 'Imported'
                      AND mi.datereceived BETWEEN inStartDate AND
nvl(inEndDate, add_months(inStartDate, 6));
                BEGIN
                    IF (invpdcnt != 0)
.
.
.
 
The line that is bold/italic seems to be getting changed to
 
             AND substr(mi.boid,0,12) = substr(incoid,0,12)
 
The script is very lengthy so I didn't want to put all of it in the
thread.
 
Sandy
 
 

==============================================================================
Please access the attached hyperlink for an important electronic communications 
disclaimer: 

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html
==============================================================================

Other related posts: