Expand|Select|Wrap|Line Numbers
- create or replace trigger .....
- v1 varchar(50);
- st varchar(50);
- ...
- begin
- ....
- v1=':NEW.'||'column_name';
- execute immediate 'select '||v1||' from dual' into st
- dbms_output.put_line(st);
- ....
But the trigger i wrote do not work, the error message is
Expand|Select|Wrap|Line Numbers
- ORA-01008: not all variables bound
What i want to achieve is to write a trigger which is working even if i change column names.