Re: Queue mechanism for Oracle standard edition

Queue mechanism for Oracle standard editioni am not sure what you mean by "lightweight" or "PL/SQL" in the given context. a queue is a queue is a queue.

create table tx q (pkey, q seqno, msg status, message, dts)

if you need multiple queues, add q no after pkey in the above table. likewise, if you need to read/write to specific jobs or processes, just add the appropriate column. if you need a persistent queue manager process, then you can use dbms job to start a daemon.

steve long
"The world's best technology strategist." (TM)

  ""ronen shachar (Kamoon IL)"" <ronens_at_il.kamoon.com> wrote in message news:95D0D1D311EFD411B495009027D616EFFB1E_at_srv mail1.il.kamoon.com...   Hello all,
  We need a queue mechanism (transactional), but we can't use Oracle advance queuing because we are working with oracle standard edition.

  Does anyone have any idea about a lightweight PL/SQL queue.

  TIA.
          Ronen.

--