ORA-22275 using a TSmartQuery with a clob

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

ORA-22275 using a TSmartQuery with a clob

Post by albourgz » 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

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: ORA-22275 using a TSmartQuery with a clob

Post by AlexP » Mon 13 Oct 2014 06:38

Hello,

We cannot reproduce the problem on the latest ODAC version. Try to reproduce the problem on the latest ODAC trial version: http://www.devart.com/odac/download.html , and let us know the results.

Post Reply