1 Reply Latest reply: Sep 1, 2004 2:46 PM by 46271 RSS

    Enterprise Manager 10g & trigger problem

    417724
      Hi.

      Trying to create a trigger using Enterprise manager 10g WEB Console and trigger creating "wizard" without success.

      Example: I've added a simple trigger using SQL+ (this works ockey):

      CREATE OR REPLACE TRIGGER "SRECKO".TESTNA_TRIG BEFORE
      INSERT ON "SRECKO"."TESTNA" REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW begin
      select testna_seq.nextval into :new.kljuc from dual;
      end;

      If I use Enterprise's Manager feature and I construct this trigger with (General/Event/Advanced) tabs it just doesn't work. I allways get the same SQL Error (missing IN or OUT parameters -> PreparedStatement bug ???).


      Has anybody had any similar experiences ?


      matev¾