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 ==============================================================================