Home » SQL & PL/SQL » SQL & PL/SQL » How to wait for a condition and timeout?
 How to wait for a condition and timeout? [message #196668] |
Fri, 06 October 2006 08:01  |
123soleil
Messages: 35
Registered: July 2006
|
Member |
|
|
Hello,
I have the following code
loop
select status into l_status from k.status where id = 210;
exit when l_status <> 'Processing';
end loop;
I'm basically waiting for my entry to go from 'processing' to 'done'. However, if the 'Done' status doesn't come say after 2 minutes, I would like my loop to stop.
How can I do this?
Thanks!
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Wed May 21 09:42:29 CDT 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
