| trigger [message #41221] |
Tue, 10 December 2002 23:44  |
vikas
Messages: 29
Registered: November 2001
|
Junior Member |
|
|
I would like to update one field
of table statemaster when its valus is
D.
I am firing trigger for update
I tried for both before update and after update.
BEGIN
IF :OLD.DNSTATUS= 'D' THEN
UPDATE STATEMASTER SET DNSTATUS = 'U';
END IF;
END;
it gives error
trigger/function may not see it
ORA-06512: at "ZIL.STATEMASTER_DBSTATUS_TRIG", line 3
ORA-04088: error during execution of trigger 'ZIL.STATEMASTER_DBSTATUS_TRIG'
|
|
|
|
| Re: trigger [message #41222 is a reply to message #41221] |
Wed, 11 December 2002 00:08  |
Todd Barry
Messages: 4819
Registered: August 2001
|
Senior Member |
|
|
create or replace trigger STATEMASTER_DBSTATUS_TRIG
before update on statemaster
for each row
begin
if :new.dnstatus = 'D' then
:new.dnstatus := 'U';
end if;
end;
/ |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
