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!

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

Original text of this message