Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to loop table every 1 second for no more than 4 seconds

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

From: Jun <frankjunli_at_gmail.com>
Date: 27 Nov 2006 05:37:57 -0800
Message-ID: <1164634677.119851.184990@j72g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US