dbms_alerts on multiple updates

From: MikeH <mike.hammett_at_associates-wheatley.co.uk>
Date: Fri, 22 Aug 2003 14:25:04 +0000 (UTC)
Message-ID: <bi593u$8tp$1@titan.btinternet.com>

Hi,

I want my Delphi application to be able to detect updates on a particular table and then write the record to an XML document. At the moment I am using dms_alert to notify my application everytime an update is made, my application then proceeds to write out the XML document.

This works fine when I update only one record at a time, however when multiple records are updated my Delphi application is unable to detect all the alerts. I appreciate that I may be able to use some form of multi-threading, but I would be interested to know if there is another Oracle package that will help me acheive this.

Thanks Received on Fri Aug 22 2003 - 09:25:04 CDT