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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: updating problems

Re: updating problems

From: Giovanni Cuccu <giovanni.cuccu_at_gmail.com>
Date: Fri, 5 May 2006 14:33:13 +0200
Message-ID: <23e0d1170605050533h4773d9d8xb8959257a6b97255@mail.gmail.com>


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-l
Received on Fri May 05 2006 - 07:33:13 CDT

Original text of this message

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