How to tell if a TOraSession is busy?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
jdorlon
Posts: 202
Joined: Fri 05 Jan 2007 22:07

How to tell if a TOraSession is busy?

Post by jdorlon » Mon 06 Mar 2017 15:31

Hello,

Is there a property or function that I can check on a TOraSession to see if it is busy executing a TSmartQuery or some other query type?

Thanks,

John

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

Re: How to tell if a TOraSession is busy?

Post by MaximG » Thu 09 Mar 2017 09:21

Please specify the functionality you are interested in. Several queries can be executed in the same Oracle session. It is necessary to determine whether the session is busy with query execution or not.

jdorlon
Posts: 202
Joined: Fri 05 Jan 2007 22:07

Re: How to tell if a TOraSession is busy?

Post by jdorlon » Fri 10 Mar 2017 13:50

Thanks for your reply. I thought one query would wait while the other one was executing. I'll take another look at my code.

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

Re: How to tell if a TOraSession is busy?

Post by MaximG » Tue 14 Mar 2017 09:12

The required functionality will be determined by the business logic of your application. When there is one thread access during execution of any long query to DB you will not be able to refer to the appropriate TOraSession component. We hope that after analyzing your application code you will be able to find the right problem solution.

Post Reply