Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: HELP: SQL*PLUS 3.3
declare a variable
then assign the :old.field to the variable
and pass the variable to the procedure
On 21 Feb 1997 20:10:58 GMT, "Darren Young" <dly_at_nbnet.nb.ca> wrote:
>I am trying to write a BEFORE DELETE trigger for a table that has two FK's
>but even when the trigger complies I get an error.
>
>Is there any body out there that knows how to pass the current values to a
>procedure in a trigger. I have tried to pass :old.field name but the error
>message that I got said that I can't use :old in this way.
>
>Thanks,
>
>Darren Young
>dly_at_nbnet.nb.ca
>
Received on Tue Feb 25 1997 - 00:00:00 CST