Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: updating problems
Ciao Simone,
you can update the column values using Pl/SQL code not a SQL command here is an example very close to your requirements:
create or replace trigger NtfRcpt_lastUpdate
before insert or update on Notifications_Recipients
for each row
declare
On 5/5/06, Simone Saravalli <s.saravalli_at_gmail.com> wrote:
> Hi all, I've got a table with two columns (say column A and column B).
> The B data type is date and its default value is CURRENT_TIMESTAMP.
> When I make an update on col A I would like to update also B with a
> new current_timestamp value, so I created a trigger that fires after
> an update on A but I obtain an error, in fact when the trigger tries
> to update col B it says that it's impossible because the table is
> updating col A.
> How can I solve this problem?
>
> Thanks, Simone Saravalli
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- -------------------------------------------------------------------- Another free oracle resource profiler http://sourceforge.net/projects/oraresprof/ Now version 0.9 -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 05 2006 - 07:33:13 CDT