| trigger not working [message #371357] |
Fri, 06 October 2000 05:42 |
shylaja
Messages: 1
Registered: October 2000
|
Junior Member |
|
|
The following trigger is giving compilation error. Can u help me to solve this?
Code is
create or replace trigger login_trigger
after update on users
for each row
when (new.login_status ='Y')
begin
update users set :new.login_status := 'N'
where :new.login_status ='Y'
end;
Its giving
Errors for TRIGGER LOGIN_TRIGGER:
LINE/COL ERROR
-------- -----------------------------------------------------------------
2/18 PLS-00103: Encountered the symbol "" when expecting one of the
following:
( <an identifier> <a double-quoted delimited-identifier>
Please help me to solve this problem.
Thanks in advance
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
