Toggle navigation
Toggle navigation
Home
Products
About us
Support
Contact
Try it free
order
Register
Log In
Forums
Products
Direct Oracle Access
How to define a timeout to a TOracleQuery?
Search
Advanced Forum Search
Forums
Active Threads
Print Thread
How to define a timeout to a TOracleQuery?
#65359
02/06/24
02:20 AM
Joined:
Feb 2024
Posts: 1
J
jevelio
OP
Member
OP
jevelio
Member
J
Joined:
Feb 2024
Posts: 1
It is required to define a timeout on database queries to continue in case the database does not respond.
I didn't find any property in the TOracleQuery object that could help me
Thanks for the help
Copy Link to Clipboard
Re: How to define a timeout to a TOracleQuery?
jevelio
#65364
02/06/24
09:52 AM
Joined:
Aug 1999
Posts: 22,597
Marco Kalter
Member
Marco Kalter
Member
Joined:
Aug 1999
Posts: 22,597
The TOracleQuery or TOracleSession do indeed not have any property or method for this. You would need to run the query in a background thread and call TOracleSession.BreakExecution from the main thread if the query needs to be cancelled.
Marco Kalter
Allround Automations
Copy Link to Clipboard
Moderated by
support
Hop To
Products ------
Plyxon
PL/SQL Developer
Direct Oracle Access
Query Reporter
Alpha / Beta releases ------
PL/SQL Developer 16.0 Beta
Plyxon Alpha / Beta
Print Thread
Switch to Threaded Mode
Show Likes
Link Copied to Clipboard
View Profile
Private Message
Follow User
Forum Posts
View Profile
Private Message
Follow User
Forum Posts
Privacy Policy
·
Forum Rules
·
Mark All Read
Contact Us
·
Forum Help
·
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:
PHP:
7.1.33
Page Time:
0.038s
Queries:
14 (0.014s)
Memory:
2.4966 MB (Peak: 3.0399 MB)
Data Comp:
Off
Server Time:
2025-03-27 07:18:48 UTC
Valid HTML 5
and
Valid CSS