Re: Trigger

From: Dirk Sudheimer <sudheimer_at_gmx.de>
Date: Wed, 05 Apr 2000 15:16:24 +0200
Message-ID: <38eb3f68.0@juno.wiesbaden.netsurf.de>

On Wed, 5 Apr 2000 14:53:48 +0200, "Birgit Kemnitz" <B.Kemnitz_at_deutschepost.de> wrote:

>Hello,

Hello Birgit,

>I need some help for creating triggers.
>I always get the mistake ''ORA-04082: NEW or OLD references not allowed in
>table level triggers"

as this error message implies,
:new and :old are only available in row level triggers.

>the trigger description is
>create or replace trigger protokoll
>before delete or insert or update on kostenstelle
>declare

this declares a table level trigger.

> <snip>

greetings

Dirk Received on Wed Apr 05 2000 - 08:16:24 CDT