Page 1 of 1

How to tell if a TOraSession is busy?

Posted: Mon 06 Mar 2017 15:31
by jdorlon
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

Re: How to tell if a TOraSession is busy?

Posted: Thu 09 Mar 2017 09:21
by MaximG
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.

Re: How to tell if a TOraSession is busy?

Posted: Fri 10 Mar 2017 13:50
by jdorlon
Thanks for your reply. I thought one query would wait while the other one was executing. I'll take another look at my code.

Re: How to tell if a TOraSession is busy?

Posted: Tue 14 Mar 2017 09:12
by MaximG
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.