Limit SQL query runtime

[oracle_faq]

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.

[Scorby]

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.