Re: how to loop table every 1 second for no more than 4 seconds

Jun wrote:
> I have a problem with PL/SQL stored procedure.
>
> loop, checking the table every 1 second for no more than 4 seconds
> if response that one specifid field in table is changed, return a
> message
> if no response is found in 4 seconds, return a timeout error
>
>
> Thanks in advance for any help

Steve is correct. I'd really like to know the business case as this sounds ... well to be politically correct ... interesting.

That said you can do this with Advanced Queuing or with the DBMS_ALERT built-in package. State the business case, and your Oracle version, and you might get better help.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org