Devart Forums

Sample project source: http://s000.tinyupload.com/?file_id=005 ... 2537543799 (78 KB)

With a 9.5.15 single occurrence on TSmartQuery.Open call only.
With a 9.6.22 occurrences on TSmartQuery.Open call and also on each TOraProvider.GetRecords call.

We have investigated behavior of TOraProvider using your sample on ODAC versions 9.5.15 and 9.6.22 . Unfortunately, we found no difference in behavior of TOraProvider between these versions. We are going to discontinue support for TOraProvider shortly. Instead of it, for work with ClientDataset, you can use the TDataSetProvider component distributed with Delphi IDE