Skip to Main Content

This trigger is giving error for me.What is the error?

Karthik PerumalAug 14 2011 — edited Aug 14 2011
The following trigger:

create or replace trigger my_trigger
before update on employees
for each row
begin
insert into kperumal values(first_name);
end my_trigger;

is giving the following error:

ERROR at line 2: PL/SQL: SQL Statement ignored

1. create or replace trigger my_trigger
2. before update on employees <- This is where error is coming.
3. for each row
4. begin

Can someone help me?
Comments
Post Details
Added on Aug 14 2011
3 comments
52 views