Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: dbms_alerts on multiple updates
The dbms_alert package actually signals event only after commit is made.
So, Your problem is something else.
"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
Received on Fri Aug 29 2003 - 07:07:26 CDT