Trigger and bind variable

From: Jochen Bedersdorfer <beders_at_dfki.uni-sb.de>
Date: 1998/03/25
Message-ID: <351954AE.52476943@dfki.uni-sb.de>#1/1

Hi,

as it seems, I can't use a bind variable or correlation name of a trigger as a ROWTYPE.

I want to call a Pl/SQL procedure from an update trigger, that takes an table%ROWTYPE as parameter.

If I try to use something like do_it(:new), I get PLS-00049: bad bind variable 'NEW'

Does anyone a work around or do I have to duplicate code unnecessarily...

Thanks in advance,
Jochen

--
+----------------------------------------------------------------------+


| beders_at_dfki.uni-sb.de  DFKI German Research Center for AI            |

| http://www.dfki.uni-sb.de/~beders                                    |

+----------------------------------------------------------------------+

Received on Wed Mar 25 1998 - 00:00:00 CST