| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Trigger created with compiler error (Ora9i)
If I try to execute a local script on the SQL *Plus Worksheet to
create a trigger, I alway get the warning: Trigger created with
compiler error.
Is this an Oracle problem or is it that my sql source code is wrong?
Here is my source code, please help!
CREATE or replace TRIGGER "xxx"."name" AFTER INSERT ON "xxx"."tablename"
FOR EACH ROW begin
insert into table
( user,
action,
table,
old,
new,
time)
values
( principal_name,
'insert',
'table',
'',
:new.id,
'02.02.02');
![]() |
![]() |