Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#21 Update field not cleared.

open-accepted
Mark Hessling
None
5
2008-03-11
2008-02-13
oorexxpert
No

Doing a PREPARE followed by multiple EXECUTES of UPDATE to an Oracle table results in fields contains residual data from previous update. Example:

sql_statement = 'UPDATE "TABLE" SET "VARCHARCOL" = ?' 'WHERE KEY = ?';
.
.
if sqlexecute("U1","CHAR","ABCDEF","CHAR",key1) < 0 then
call sql_error "Update U1";

if sqlexecute("U1","CHAR","XYZ","CHAR",key2) < 0 then
call sql_error "Update U1";

Results in record KEY2 having a value of "XYZDEF" for column VARCHARCOL.

Using rxsql24_odbc_w32 against Oracle database on Windows server.

By doing a OPEN, PREPARE, DISPOSE, CLOSE for each UPDATE, it works correctly.

John_bodoh@infrawise.com

Discussion

  • Mark Hessling
    Mark Hessling
    2008-03-11

    Logged In: YES
    user_id=86185
    Originator: NO

    I have confirmed this bug, and have determined the problem to be related to bind variables. Will fix ASAP.
    This bug is likely to affect all database drivers that allow bind variables.

     
  • Mark Hessling
    Mark Hessling
    2008-03-11

    • assigned_to: nobody --> rexx
    • status: open --> open-accepted