Re: triggers and stored procedure

Hi there,

A trigger can be define on any dml (insert, update or delete) statements and is executed automatically before or after depending on how it is specified in your trigger.

Whereas a stored procedure / function can be called to execute it.

The best link is technet.oracle.com
and Oracle documentation and Oracle press books are good sources.

SD.

"Loki" <rinze_cats_at_hotmail.com> wrote in message news:9bhf2n$57eph$1_at_reader02.wxs.nl...
> hi!
> what is the relation and/or difference between these triggers and stored
> procedures. To my knowledge they are both used to automatically perform
> certain actions when an event occurs. So,
> in what case should i define a trigger using Pl/SQL en when do I use a
> stored procedure?
>
> if I am way of base here, please let me know ;-)
> Oh yeah, I am also looking for a good link with information on stored
> procedures (and how to define them)
>
> many thanx,
> rinze
>
>
>
Received on Tue Apr 17 2001 - 15:23:31 CDT