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

Jun wrote:
> Thanks for all of your help.
> Let me get more specifid.
>
> I am working on Oracle 9i
> I am supposed to write a PL/SQL strored procedure to create a new
> record with 'status' field in one table.
> and some existing trigger will check the new record and set the value
> of 'status'
>
> my task after record creation is to loop the table every 1 second for
> no more than 4 seconds to
> check if the status field has been changed to the value 'completed.
> if yes, return a successful message
> if no, set the value of status to timeout and return a timeout error.
>
>
> thanks again for all your help

But why? Why is 3.9 seconds a good value and 4.1 seconds a failure? And what do you mean by "an existing trigger?" How does the trigger do this?

The entire concept you are describing sounds like a reinvention of the wheel. That wheel named Advanced Queuing.

-- 
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