SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to set timeout for PLSQL block or query inside procedure?

Khamis KhalilMar 17 2021 — edited Mar 17 2021

I know we can set timeout using resource manager at schema level. But I want to set timeout to a specific query inside a procedure and catch the exception. lets say i want to stop query execution for specific query after 15 secs. Is there any way for this? Or any timeout exception available? I am using Oracle Db 12.2. Thanks.

Added on Mar 17 2021

4 comments

5,921 views

2 mentions