[Oracle-l] 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

local variables here
begin
:new.Last_Update:=sysdate;
end check_enabled;
/
Hope it helps,
Giovanni

full code, table descriptions and probably most useful would be the error
please

Forwarded message ----------
From: Simone Saravalli
Date: 5-mag-2006 14.40
Subject: Re: updating problems
To: Ghassan Salem

2006/5/5, Ghassan Salem :
Yes, this is an example of the table I want to update:

create table tab (

a number not null,
b date default current_timestamp
);

and then the trigger

create or replace trigger my_trig

after update of a on tab for each row
begin

update tab set b = current_timestamp where a=:new.a;
end;
/

Now I've written:

create or replace trigger my_trig

after update of a on tab for each row
begin

update tab set :new.b = current_timestamp where a = :new.a;
end;
/

but the trigger gets some compilation errors. Is it correct?

Thanks, Simone Saravalli

First, you should do this in "before" trigger.
Second, you don't need "update" statement in the trigger (just do an
"assignment").


create or replace trigger my_trig

before update of a on tab for each row
begin

:new.b = current_timestamp;
end;
/

And third, read some oracle docs.

Igor

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Simone Saravalli
Sent: Friday, May 05, 2006 8:42 AM
To: oracle-l
Subject: Fwd: updating problems

Forwarded message ----------
From: Simone Saravalli
Date: 5-mag-2006 14.40
Subject: Re: updating problems
To: Ghassan Salem

2006/5/5, Ghassan Salem :
Yes, this is an example of the table I want to update:

create table tab (

a number not null,
b date default current_timestamp
);

and then the trigger

create or replace trigger my_trig

after update of a on tab for each row
begin

update tab set b = current_timestamp where a=:new.a;
end;
/

Now I've written:

create or replace trigger my_trig

after update of a on tab for each row
begin

update tab set :new.b = current_timestamp where a = :new.a;
end;
/

but the trigger gets some compilation errors. Is it correct?

Thanks, Simone Saravalli