Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers???
put a / on the next line after end
-- Andrew - Wizzard barnetaj_at_bp.com Peter Chan <chanp_at_nortel.ca> wrote in article <3506D471.687C_at_nortel.ca>...Received on Wed Mar 11 1998 - 00:00:00 CST
> 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
>
> --
>