Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_alerts on multiple updates
"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
![]() |
![]() |