Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger created with compiler error (Ora9i)

Trigger created with compiler error (Ora9i)

From: odette <odette.h_at_gmx.de>
Date: 11 Feb 2002 04:53:06 -0800
Message-ID: <66e0618e.0202110453.47a03e2d@posting.google.com>


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');

end; Received on Mon Feb 11 2002 - 06:53:06 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US