Re: triggers and stored procedure

Hi!

A trigger is run automatically by the database on a defined event; e.g before or after an insert is perfomed in a table, or (in O8i) upon login or logoff from database.

A stored procedure/function must be called actively by the developer (this may be done in a triggers logic though). A stored procedure is similar to a function/procedure in any other language.

If you have installed e.g personal oracle on a PC there is a documentation related to Oracle which is full of PLSQL documentation. There are numerous books also, I have used "Oracle PL/SQL Programming" by Steven Feuerstein (O'Reilly & Associates, Inc). I believe it is easier to learn a language if you read a textbook cover to cover.

Frank

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 - 13:13:56 CDT