#21 Update field not cleared.

[oorexxpert]

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

[Mark Hessling]

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.