Is there a way put a time limit on a query in PL/SQL. Say if I have a cursor/for loop and the corresponding query does not return data in 10 seconds, just continue and don't perform that operation.
Printable View
Is there a way put a time limit on a query in PL/SQL. Say if I have a cursor/for loop and the corresponding query does not return data in 10 seconds, just continue and don't perform that operation.
The neareast you could probably get is to set up a profile for the user running the proc, then catch the error when the query times out in your PL/SQL.