Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to loop table every 1 second for no more than 4 seconds
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 Received on Mon Nov 27 2006 - 07:37:57 CST