dsatya10
Last Activity: Dec 25 '11, 06:45 AM
Joined: Dec 22 '11
Location:
-
dsatya10 replied to please resolve this problem i am getting this error after running this procedurein Oraclethanks now it is working -
dsatya10 started a topic please resolve this problem i am getting this error after running this procedurein Oracleplease resolve this problem i am getting this error after running this procedure
create or replace procedure add_cons is
type tname_type is table of varchar2(20);
table_name tname_type := tname_type('EMP _MUMBAI','EMP_N AGPUR');
dml_stat varchar2(500);
begin
for i in table_name.firs t..table_name.l ast loop
dml_stat:='alte r table' ||table_name(i) || 'add(OUTPUT_DAT E date default sysdate)';
execute immediate dml_stat;
end loop;
end;
/
ERROR at line 1:
...
No activity results to display
Leave a comment: