Re: Triggers???

Hi Peter,
i think you need to add a slash (/) at the end of the bogus_trig.sql Hope this help.

Michael

Peter Chan <chanp_at_nortel.ca> schreibt: > 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 Mon Mar 16 1998 - 00:00:00 CST