ORA-22275 using a TSmartQuery with a clob
Posted: Fri 10 Oct 2014 12:19
Using bcb XE6 and odac 9.4.11.
I have a TSmartQuery based on a table with some fields and a clob, used as source of a TDBCtrlGrid component. This grid holds a TDBMemo field (type ftMemo).
Only updates are done in the TDBCtrlGrid , no insert, no delete.
Data is correctly read, if I update the memo, when calling smartQuery->ApplyUpdates(), I get a ORA-22275 error (invalid LOB locator).
I tried to change the field type from ftMemo to ftOraClob, no change.
This app worked with bcb 2010/odac 6.x (so this is a regression).
Any hint / fix?
Regards,
Alain
I have a TSmartQuery based on a table with some fields and a clob, used as source of a TDBCtrlGrid component. This grid holds a TDBMemo field (type ftMemo).
Only updates are done in the TDBCtrlGrid , no insert, no delete.
Data is correctly read, if I update the memo, when calling smartQuery->ApplyUpdates(), I get a ORA-22275 error (invalid LOB locator).
I tried to change the field type from ftMemo to ftOraClob, no change.
This app worked with bcb 2010/odac 6.x (so this is a regression).
Any hint / fix?
Regards,
Alain