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-downwithspammersfamily_at_attbi.net>
Date: Fri, 22 Aug 2003 15:46:19 GMT
Message-ID: <eVq1b.170256$cF.57935@rwcrnsc53>


You cannot do it the way you want.
Jim
"MikeH" <mike.hammett_at_associates-wheatley.co.uk> wrote in message news:bi5c9b$hok$1_at_hercules.btinternet.com...
> Thanks for the reply Jim, the only problem is that I would like the
trigger
> to fire only after commit, this will ensure that I am writing the new
record
> data to the XML document. I have tried using pipes already , however I
> understand that dbms_pipes are not transactional and therefore they donot
> fire after commit.
>
> Thanks
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_no_spam.comcast.net> wrote in
> message news:liq1b.172933$It4.83662_at_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:46:19 CDT

Original text of this message

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