process row after periodic wait
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 16 Mar 2004 10:54:17 +0530
Folks,
How may the following (in CAPITALS) be implemented?
STEPS:-
1) a row inserts into a particular Table
2) WAIT 30 seconds for the row to be processed by some unrelated service
3) After 30 seconds CHECK if the row has been processed
4) If not processed , MOVE the row into another Table
NOTE - Multiple row Inserts occur at differing points of time, some may
even occur concurrently
Thanks
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
