Timeout for TQuery and TStoredProc component

roznicki · Post by **roznicki** » Mon 08 Mar 2010 09:29

Do you plan to add timeout for query or stored procedures in next release? There is timeout for connection but it would by fine to decide how long query or stored procedure should be executed. Similiar feature is in JDBC drivers and it is working perfectly with Oracle (I haven't tested it with other databases).

Challenger · Post by **Challenger** » Tue 09 Mar 2010 09:14

We have no such plans because OCI does not support such parameter. We can implement it for Direct mode only.

roznicki · Post by **roznicki** » Tue 09 Mar 2010 09:47

Timeout for query and stored procedures in direct mode would be cool feature.
For OCI connection you can create a Timer and issue an OCIBreak() on timeout. OCIBreak() is thread safe and signal safe.
Please think about this feature in future releases.