RE: process row after periodic wait

From: <oracle-l-bounce_at_freelists.org>
Date: Tue, 16 Mar 2004 09:06:53 -0500
Message-ID: <91AFBA9B76078B4E8340A383EADEF1DB7EE56C@syn2kex1.smdi.com>

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_at_infosys.com] Sent: Tuesday, March 16, 2004 12:24 AM
To: oracle-l_at_freelists.org
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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 16 2004 - 08:03:26 CST