you cannot reference new and old as records. therefore, you must either
pass each element as an individual parameter, or assign them individually
to elements of a record and pass that.
--
Andrew - Wizzard
barnetaj_at_bp.com
Jochen Bedersdorfer <beders_at_dfki.uni-sb.de> wrote in article
<351954AE.52476943_at_dfki.uni-sb.de>...
> 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
