ora-01410. doa 4.3.1.5

[SkipUFO]

I use DOA 4.3.1.5 (last).
I have a table with id (integer PK), text (varchar2(50))

I have record, for example, id = 1, text = '0'.
I use TOracleDataSet with 'select t.rowid, t.* from table'.
I have rowid AABXFyAAEAAFEg+ABG (with + or / symbolshttp://docs.oracle.com/cd/B19306_01/server.102/b14220/datatype.htm#sthref3894)

when I try ds.FieldByName('text').AsString := ''; I receive ORA-01410: Invalid rowid.

I trace session, and I see:
update table set text = null where rowid = :doa__rowid returning rowid into :doa__rowid

with doa__rowid = AABXFy. I see it's trimmed. Why - is the question.

 

[Marco Kalter]

Can you let me know your Delphi version? I will try to reproduce.

 

[SkipUFO]

delphi xe7 update1

 

[SkipUFO]

Can you let me know your Delphi version? I will try to reproduce.

Did you reproduce? May you need be some additional info?

 

[jbeck]

Hi Marco,
we have the simliar problem with Invalid rowid. It occurs, if a field in a dataset (cached updates) is set to NULL or a string field is set to an empty string. Not every time but often.
In the oracle monitor the rowid seems to be correct. It never happens on the same queries when the field is updated to something different then NULL. In this case in oracle monitor the rowid is the same as when the error occurs.

- Delphi XE7 update 1
- Oracle Database 11g Release 11.2.0.1.0 - 64bit Production
- DOA 4.1.3.5

Thank you for your support.
Best regards
Joachim