Alter table inside a trigger
RAMJANEApr 19 2009 — edited Apr 25 2009Hi All,
I want to write an alter table statement inside trigger definition.
I did it as show below:
create or replace trigger testme before insert on emp1
begin
alter table emp1 modify name varchar2(20);
end;
but it is showing me error ORA:04098 at the time of insert into table.
Please help me.
Thanks in advance.
Anil