Using :new and :old as parameters to Stored Proc

Hi all,

I have a stored procedure on the form

        StoredProc(MyVar IN MyTable%ROWTYPE)
and want to call it from a trigger on the table MyTable using the trigger variables :new or :old as:

StoredProc(:new);

This seems not to be allowed, however, since :new isn't a variable of the specified rowtype (I get PLS-00049: Bad bind variable). Is there any way at all to accomplish what I want to do?

Regards,
Øyvind. Received on Tue Mar 23 1999 - 09:25:59 CST