Re: HOW TO: use trigger for accounting
From: Alvin Law <alaw_at_oracle.com>
Date: 4 Jan 95 01:17:55
Message-ID: <ALAW.95Jan4011755_at_ap226sun.oracle.com>
> wich it was fired. Is there any way to do this without using a temporary table
> and a trigger after to the all table ?
Date: 4 Jan 95 01:17:55
Message-ID: <ALAW.95Jan4011755_at_ap226sun.oracle.com>
In article <3dpftk$iti_at_master.di.fc.ul.pt> jav_at_master.di.fc.ul.pt (Jose Augusto Venceslau) writes:
> I need to allow a trigger for each row to do an insert on the table to
> wich it was fired. Is there any way to do this without using a temporary table
> and a trigger after to the all table ?
You should be able to meet your requirement by using a row-level post-insert db trigger. Check the Server Application's Guide for details.
-- ___ (o o) +-oo0-\_/-0oo---------------------------------------------------------------+ | Alvin Law .. Project Leader, Applications Division ... Oracle Corporation | | Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299 | +---------------------------------------------------------------------------+ ORA-03113: end-of-file on communication channelReceived on Wed Jan 04 1995 - 01:17:55 CET