Subject | Re: i want to update datas of parametric tablename in trigger |
---|---|
Author | lacakus |
Post date | 2009-09-04T10:44:02Z |
>what about using dynamic dml ?:
> CREATE OR ALTER TRIGGER CUST_BU0 FOR CUST
> ACTIVE BEFORE UPDATE POSITION 0
> AS
> ....
> begin
> .....
>
execute statement 'update account' || cast(new.type as varchar(3)) || ' set balance=balance+new.total;';
-Laco.