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;
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 ???).
I am having the same problem. Unfortunately, it looks like no one else is or no one else has an answer. I will check back again later. Right now I am going to try and google and answer. Hope someone responds here.