:new & :old as records ?

Hi all!

When I wrote a row-level triggers in Oracle I frequently need to pass a whole set of record fields values to a procedure. But I can't. :new and :old is only referencing, they aren't treated as real records by Oracle. If I wrote somewhere in the trigger

my_procedure(:new)

then PL/SQL cry : "Invalid binding variable."

Why ?!

And why I can SELECT whole record but can't INSERT it? Are there any real reasons ?

Does Oracle plan to solve this problems, does anybody know ?

Alexandr Alesinsky,
JSV Investor Received on Tue Aug 01 1995 - 00:00:00 CEST