Triggers - :new - pseudorecord
From: Jeremy <jeremy0505_at_gmail.com>
Date: Mon, 16 Sep 2013 17:35:41 +0100
Message-ID: <MPG.2ca143ba72c6cdaf989739_at_news.individual.net>
Hi
Date: Mon, 16 Sep 2013 17:35:41 +0100
Message-ID: <MPG.2ca143ba72c6cdaf989739_at_news.individual.net>
Hi
l_rec mytab%rowtype;
begin
l_rec := :new;
end;
What we wanted to do was to pass the whole row to a plsql procedure whose definition was e.g.
procedure myproc (p_rec in mytab%rowtype)
is
.....
I realise this is not possible and that we would need to assign all the variables explicitly e.g.
l_rec.col1 := :new.col1;
l_rec.col2 := :new.col2;