Rowtype as parameter

From: David Braverman <dbraverman_at_ecapsrewsna.com>
Date: Thu, 18 Jun 1998 15:24:00 -0400
Message-ID: <6mbpg8$4cp_at_news.dx.net>

I have no experience whatever programming PL/SQL, but I have extensive programming experience otherwise.

I want to create an insert or update trigger that manipulates data from the last inserted row. I want to pass the row from the trigger into a procedure. The following code does not work:

CREATE OR REPLACE TRIGGER Table_Upd
after insert or update on TableName
for each row
begin

    Procedure(:New_at_ROWTYPE);
end;

Will this or anything like it actually work? Received on Thu Jun 18 1998 - 21:24:00 CEST