Re: Oracle Stored Procedures

From: Knut Talman <knut.talman_at_mytoys.de>
Date: Wed, 16 May 2001 11:22:53 +0200
Message-ID: <3B0246ED.7CD00218@mytoys.de>

> Can anybody tell me what the difference is between
> CREATE OR REPLACE PACKAGE
> and
> CREATE OR REPLACE TRIGGER
You can understand a PACKAGE as a collection of procedures, functions, types which you have to call by yourself (explicitly). A TRIGGER is called implicitly when the condition, the trigger was designed for, becomes true (e.g. when you insert a row into the table, the trigger belongs to). A trigger is always connected to a table, it can not be run standalone.

Regards,

Knut Received on Wed May 16 2001 - 04:22:53 CDT