NEED HELP w/ TRIGGER problem
Mike Stenzler wrote:
<Bits removed>
THIS FAILS:
create trigger t_upt1
update of c1, c2 on t1
referencing old as o new as n
for each row (execute procedure sp_calct1(n.c1, n.c2) into c3)
after (execute procedure sp_upt2(c4, c5)); ^^^^^
If this is exactly what you have, your problem is that you are not
prefixing c4/c5 with the record id 'o' or 'n' ie o.c4, o.c5. This aught
to solve your problem.
THIS SUCCEEDS:
create trigger t_upt1
update of c1, c2 on t1
referencing old as o new as n
for each row (execute procedure sp_calct1(n.c1, n.c2) into c3)
after (execute procedure sp_upt2());
Mark Denham
BBC
London, UK
Mark.Denham@bbc.co.uk