Borland Delphi with latest version of ODAC with patches from 02-sep-05. Oracle 9.2 server & client.
We have Fields with varchar2(4000) on our tables. We are treating these fields as TMemoFields in ODAC(LongString option on Query). When we update the field, ODAC uses all 4000 characters , eventhough field has only 4 characters, as result our trigger which creates insert/update/delete sql statements are getting truncated at the where clause( as posted in my previous post). We proved this by adding RTRIM to the trigger before the field name, but this is not an option for us, since there are more than 50 users using this application on laptop running on personal oracle. We have got the same application running on Oracle 9 server.
Any help will be highly appreciated.
Thanks,