Problem updating text field containing special characters in Oracle 10g from VB
Posted on 2009-07-14
We recently upgraded from Oracle 9i to 10g.
We periodically update an Oracle table using a VB program.
One of the rows to be updated contains the special character corresponding to "1/2".
When the UPDATE SQL statement attempts to update that row, the OLEDB provider for Oracle returns the following error:
ROW-00014: Cannot update row as the data in the database has changed
If we remove that character, the updates completes successfully. The update never complained under 9i.
Unfortunately, a response was not given to the issuer of the related question I found in your forum.
Any Idea how to resolve this issue?
Thanks in advance