Home » RDBMS Server » Server Administration » trigger not working
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
Previous Topic: Select Where NULL - HELP
Next Topic: Can't create trigger. help me!
Goto Forum:
  


Current Time: Thu Mar 28 03:52:53 CDT 2024