Question with TOraSQLMonitor

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Ping Kam
Posts: 21
Joined: Fri 26 Nov 2004 19:09

Question with TOraSQLMonitor

Post by Ping Kam » Fri 26 Nov 2004 20:44

I used to see the fetch command in the previous version of ODAC but seems like it is not supported in the current version. I have added all traceflags but it doesn't work.

And it is very strange with Prepare. If I do not enable KeepPrepared, I do not see the prepare command in the DBMonitor or the SQLMonitor. If I enable the KeepPrepared, the the prepare command issued after the query execute command. If I manually prepare the SQL, I can see the prepare command, but there is no execute command when I open the query. And no command when I manually unprepare the query.

Thanks,
Ping Kam

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Tue 30 Nov 2004 14:14

DBMonitor can show the following operations: Prepare, Execute, Connect,
Disconnect, Commit, Rollback, Error messages.
Thank you for information, you found a bug with Prepare. We will fix it in the next ODAC build.

Ping Kam
Posts: 21
Joined: Fri 26 Nov 2004 19:09

Post by Ping Kam » Tue 30 Nov 2004 16:19

Thanks for your reply.

If I remember correctly, Fetch is working in ODAC4. Any reason why it is de-supported in the current version of ODAC? Will it be back later or gone forever?

Paul
Posts: 725
Joined: Thu 28 Oct 2004 14:06

Post by Paul » Thu 02 Dec 2004 07:42

DBMonitor did not show fetch operation. Please check ODAC 4 again.

Post Reply