Re: commit trigger

How time sensitive is it?

You could use materialized views.

You could just have the trigger update a timestamp on the column. If you don't commit it won't change. The Java app will never see it.

You could have thr trigger send an alert or put something in a pipe (info that the Java app can use like rowid or primary key of the row)

Jim

"Pascal Byrne" <p_byrne76_at_hotmail.com> wrote in message news:c1d21c59.0110180154.4baebe6_at_posting.google.com...
> 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 Fri Oct 19 2001 - 22:00:15 CDT