RE: process row after periodic wait - Off Topic
- From: "VIVEK_SHARMA" <VIVEK_SHARMA@xxxxxxxxxxx>
- To: <oracle-l-bounce@xxxxxxxxxxxxx>
- Date: Thu, 18 Mar 2004 15:57:27 +0530
Is such an option / similar one available in MS SQL Server ?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, March 16, 2004 7:37 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: process row after periodic wait
Sounds like a good job for advanced queueing to me. Instead of
inserting the row to a table, add it to a queue. The unrelated service
pulls rows from the queue where they are now unavailable to other
processes. I think you can put a 30 second delay in the queue, so that
you can read rows that are still in the queue after 30 seconds, and
insert into the other table.
-----Original Message-----
From: VIVEK_SHARMA [mailto:VIVEK_SHARMA@xxxxxxxxxxx]
Sent: Tuesday, March 16, 2004 12:24 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: process row after periodic wait
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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
----------------------------------------------------------------
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:
- » RE: process row after periodic wait - Off Topic
