Why do I always get a compiler error???
From: odette <odette.h_at_gmx.de>
Date: 11 Feb 2002 04:54:19 -0800
Message-ID: <66e0618e.0202110454.cd36fe1_at_posting.google.com>
[Quoted] [Quoted] 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!
end; Received on Mon Feb 11 2002 - 13:54:19 CET
Date: 11 Feb 2002 04:54:19 -0800
Message-ID: <66e0618e.0202110454.cd36fe1_at_posting.google.com>
[Quoted] [Quoted] 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, [Quoted] '02.02.02');
end; Received on Mon Feb 11 2002 - 13:54:19 CET