Triggers???

I am new at writing triggers.

I don't know where to beging or how to load in a trigger when I have finished writing it.

I have the following code inside of a file "bogus_trig.sql":

create or replace trigger bogus_trig
  after
  insert or delete or update
  on bogus
  begin
    insert into temp values ('A');
  end;

Then after loading in the trigger, I still get a prompt with a line number and I am not brought back to my regular prompt.

I don't know why I can't seem to create this trigger "bogus_trig".

I have ran that script "catproc.sql" to allow me to create triggers.

Could you please let me know what I am doing wrong, thanks!

• Peter

--