Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> DBMS_ALERT.WAITANY questions

DBMS_ALERT.WAITANY questions

From: Stephane Vanhoecke <sNvOaSnPhAoMecPkLe_at_eElAaSnEsNoOfStPwAaMre.com>
Date: Wed, 16 Jun 2004 14:23:14 +0200
Message-ID: <cape3u$2lga$1@news.completel.fr>


I have somes questions about DBMS_ALERT package and WAITANY procedure.

The context is :
An application is waiting for database event (insert in a table). This application register a lot of signal identify by a special ID (about 1000 signals). This ID is a column of the waiting table. A trigger SIGNAL the ID when there is an insertion in the waiting table. The application use the WAITANY procedure to reveive events.

Problem is :
WAITANY don't return SIGNAL in a chronologic order. Questions are :
- In wich order the WAITANY procedure return raised SIGNALS ?

In the documentation, there is a chapter talking about POLLING LOOPS : If you use the WAITANY procedure, and if a signalling session does a signal but does not commit within one second of the signal.
- What is the inconvenient of POLLING LOOPS ?

Received on Wed Jun 16 2004 - 07:23:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US