Re: dbms_alerts on multiple updates

Thanks for your input Jim, do you mean I can not achieve my solution at all, or that I cannot achieve it the way that I have set out, if you mean the latter, do you have any other ideas as to how I may achieve this?

Thanks

MikeH

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:eVq1b.170256$cF.57935_at_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:51:09 CDT