please resolve this problem i am getting this error after running this procedure

[dsatya10]

create or replace procedure add_cons is
type tname_type is table of varchar2(20);
table_name tname_type := tname_type('EMP_MUMBAI','EMP_NAGPUR');
dml_stat varchar2(500);
begin
for i in table_name.first..table_name.last loop
dml_stat:='alter table' ||table_name(i)|| 'add(OUTPUT_DATE date default sysdate)';
execute immediate dml_stat;
end loop;
end;
/
ERROR at line 1:
ORA-00940: invalid ALTER command
ORA-06512: at "SCOTT.ADD_CONS", line 8
ORA-06512: at line 1

[Rabbit]

You have no space after your table and table name and no space after your table name and add.

[dsatya10]

thanks now it is working