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 -> Re: dbms_alerts on multiple updates

Re: dbms_alerts on multiple updates

From: Jim Kennedy <kennedy-down_with_spammers_at_no_spam.comcast.net>
Date: Fri, 22 Aug 2003 15:04:49 GMT
Message-ID: <liq1b.172933$It4.83662@rwcrnsc51.ops.asp.att.net>


"MikeH" <mike.hammett_at_associates-wheatley.co.uk> wrote in message news:bi593u$8tp$1_at_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
>
>

You could put the rowid in a pipe. see pipes. Jim Received on Fri Aug 22 2003 - 10:04:49 CDT

Original text of this message

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