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 Wed Oct 17 2001 - 07:11:57 CDT
