Re: what is the different of application trigger and database trigger in PL/SQL

There are different opinions about what database triggers are: 1 Triggers that fire on database events like ON LOGON (available only in and after 8i)
2 Triggers that fire on user defined rules Both are stored in the database, and so, both could be called database triggers.
In Oracle Forms, you will find this point of view in the online ducumentation.

To my mind, only triggers of type 1 are database triggers, because type 2 is user defined.
The most simple example is a sequence trigger that fires on insert of a table.

Application triggers are user defined. They can be stored in the database, but they can also reside
on a clients application, e.g. Forms and Reports. These Oracle Tools have a number predefined templates of
triggers, firing on specific Tool events, and the triggers can be filled with user defined PL/SQL.

Hope this helps.

Jan.

"In Season" <pigsing_at_yahoo.com> schrieb im Newsbeitrag news:ahmbrj$3pp1_at_imsp212.netvigator.com...
> THX~ALL
> --
> --------------------------------------------------------------
> ¬K¤Ñªº²±©ñ ¡A®L¤Ñªº¥ò©]
> ¬î¤Ñªºµ£¸Ü ¡A¥V¤Ñªº¬G¨Æ
> ¤@¤ÁºÉ¦b¤£¨¥¤¤...........

(???)

> My ftp (upload only)
> ftp://upload:upload@inseason.no-ip.com
> --------------------------------------------------------------
>
>
Received on Wed Jul 24 2002 - 09:19:53 CDT