1 2 Previous Next 18 Replies Latest reply: Oct 9, 2013 5:09 AM by Sven W. RSS

    Trigger gives error on compile

    6fe984dc-5e91-42aa-9d65-df46bf3f6fc3

      Hi,

       

      I created a trigger with a definition of

       

      "CREATE OR REPLACE TRIGGER "BDUZU"."TRGR_1" AFTER INSERT ON ADA BEGIN UPDATE ADA SET "objectid" = BDUZU.NTCD_1.NEXTVAL WHERE "objectid" = -66;"

       

      When I try to compile the trigger I get the following error message which I could not understand:

      "Error(2,77): PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: ; "

       

      Could anyone tell me what the possible reason can be?

       

      Kindest Regards

        1 2 Previous Next