Re: Triggers???

Hello Peter,

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

I think you forgot the '/' wich execute the order 'create or replace trigger....'
the ';' after the keyword end is to finish the body started with 'begin'

Good luck for writing your triggers!
Olivier

Peter Chan wrote:

> 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
> --
Received on Wed Mar 11 1998 - 00:00:00 CST