Multiple TOraSQLMonitor.OnSQL occurrences by one query

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
quwy
Posts: 1
Joined: Tue 12 Apr 2016 15:32

Multiple TOraSQLMonitor.OnSQL occurrences by one query

Post by quwy » Tue 12 Apr 2016 15:42

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.

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Multiple TOraSQLMonitor.OnSQL occurrences by one query

Post by MaximG » Thu 14 Apr 2016 12:14

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

Post Reply