EAssertion Failed Error

Karen · Post by **Karen** » Tue 20 Sep 2005 21:03

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

Alex · Post by **Alex** » Thu 22 Sep 2005 07:03

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.

Karen · Post by **Karen** » Thu 22 Sep 2005 13:16

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

Alex · Post by **Alex** » Fri 23 Sep 2005 07:45

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