Trigger Question. Use :OLD as ROWTYPE
476200Feb 8 2007 — edited Feb 8 2007Regarding table triggers before update.<br>
<br>
Is it possible to use :OLD as a ROWTYPE within the /for each row/ clause?<br>
And ditto for :NEW?<br>
<br>
Since :OLD would represent a whole row in the table we're updating - I'd like to submit the whole row into a function (with 1 input rowtype matching the table in question) and replace :NEW with the function output (identical rowtype).<br>
<br>
Is this possible without having to create a temp rowtype and copying/assigning values one by one from :OLD?<br>
<br>
Sincerely / 76°®