Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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