tim wrote:
> Hi Niall
>
> I am trying to dequeue queue items from one queue and place them into
> a normal table. The normal table would be an identical copy of the
> queue table placed in a backup schema. My approach is to select the
> item from the queue table, insert it into the normal table, then
> dequeue the item from the queue.
Why not have your existing queue also publish to a queue with a
listening procedure that loads a table?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Thu Feb 01 2007 - 11:01:17 CST
