var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Pass entire row as argument to a precedure
Hi, How do I pass the ld and :new as parameter to a precedure? I am getting
PLS-00049: bad bind variable 'OLD'.
I need to get the entire row.
Thanks in advance!
Re: Pass entire row as argument to a precedure
It can't be done, I'm afraid. You have to reference each :old and :new value individually, like this:
create trigger emp_trg after update of emp
for each row
old_rec.empno := :old.empno;
old_rec.ename := :old.ename;
new_rec.empno := :new.empno;
new_rec.ename := :new.ename;
emp_proc( old_rec, new_rec );
oh great. i've got 25 columns in a row.
Only 25? But yes, it is irritating. This question comes up quite often!