Devart Forums

Using Latest version of ODAC ( with latest patch from 02-sep) with Borland delphi 2005.

One of the tables have 3 fields with varchar2(4000). We are using this as memo field with ODAC in application. We are updating Rich Text formatted text on this fields. Each of these fields have an update trigger which creates update/insert/sql statements on a trans_out table. If we use these fields as ftMEmo, then update statements get truncated after rich text field i.e it misses where clause.

We changed to ftFmtMemo and it works fine on first field, then it gives error
"Project xxxx raised exception class EAssertion Failed with Message 'Unknown Data type (D:\Projects\Delphi\ODAC\Source\OraClasses.pas , line 2700)

Any help to use ftFmtMemo field type without error will be highly appreciated.

Thanks

We couldn't reproduce your problem, please specify your Oracle client and server versions. What VCL do you use (win32/.Net)? Are you using ODAC with Net option? If it is possible send us complete sample to demonstrate your problem and script to create server objects. Please, send this message to our ODAC support e-mail address.

Using Oracle 9.2 client/Server. ODAC latest version with patches from 02-sep-05 and using tnsnames.ora (NOT .net).

We couldn't reproduce your problem without your demo sample, please send it with scripts that creates server objects to ODAC support address.