Hello All,
I have a suggestion that maybe has already been submitted in some form in the past.
Namely, in DML before/after ROW level triggers, where we can access the pre/post values of each column
by using :OLD.col_name and :NEW.col_name, it would be very convenient to be able to access the entire record.
For any table T, we could have something like :OLD.ROW and :NEW.ROW, where OLD.ROW and NEW.ROW
are defined as RECORD data types containing ALL the columns, in the order they are defined in the table.
The only problem I see here is that, if the table contains invisible columns, then the :OLD.ROW and :NEW.ROW
“lose type compatibility” with T%ROWTYPE, which contains only the visible columns.
Or, as an alternative, :OLD.ROW and :NEW.ROW could be defined as containing only the visible columns,
so that they are fully compatible with T%ROWTYPE.
Thanks a lot for your attention & Best Regards,
Iudith Mentzel