Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: commit trigger

Re: commit trigger

From: Pascal Byrne <p_byrne76_at_hotmail.com>
Date: 18 Oct 2001 02:54:12 -0700
Message-ID: <c1d21c59.0110180154.4baebe6@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 Thu Oct 18 2001 - 04:54:12 CDT

Original text of this message

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