Re: Need Help with Trigger

In article <gdouglas.5.0000253A_at_mailhost.wlc.com>, Gerry Douglas <gdouglas_at_mailhost.wlc.com> writes
>Hi, I've just started learning Oracle and I have some problem creating trigger.
>Basically, I typed in something like this in PL/SQL:
>
> >create trigger trig_test
> 2 after insert or update
> 3 on tab1
> 4 begin
> 5 select * from tab1;
> 6 end;
> 7 .
>

You have two problems here. The first is that you you haven't created a trigger. You will need to enter '/' on the line after you PL/SQL block to execute it. You should then get a message saying whether the trigger created successfully or not.

You second problem is that "select * from tab1" is not valid in a trigger, and even if it was, nothing would be displayed (a trigger does not have access to the output of your session).

-- 
Jim Smith