Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: commit trigger
I have triggers on several tables that store summary data into a log
table for each row insert/delete/update.
When a transaction commits, I need to execute a procedure to analyse the contents of the log table so it can be broadcast to an external Java application.
The question is, how do I get Oracle to call the procedure when the session commits?
Thanks,
pascal
"Jim Kennedy" <kennedy-family_at_home.com> wrote in message news:<hAez7.26366$JN.102697_at_news1.sttls1.wa.home.com>...
> Not sure I understand what it is that you want to do. Please give a simple
> example of what you mean and what you want the stored proc to do.
>
> Jim
> "Pascal Byrne" <p_byrne76_at_hotmail.com> wrote in message
> news:c1d21c59.0110170027.69df6ca3_at_posting.google.com...
> > I need to to create a trigger in Oracle 8, that executes when a
> > transaction commits.
> >
> > The trigger will analyze data on logged changes made to specified
> > tables during the transaction and remove redundant data. So if a row
> > is updated, then deleted, only a record of the deletion is retained.
> >
> > I know there is no 'on commit' trigger in Oracle, so is there any
> > other way of doing it?
> >
> > Thanks,
> > pasal
Received on Thu Oct 18 2001 - 04:54:12 CDT