在存储过程中执行DLL语句

create or replace procedure proc_alter_xydTable(touser varchar2) is

begin

Execute Immediate 'alter table '||touser||'.fjnl add revd1 varchar2(4)';

Execute Immediate 'alter table '||touser||'.fjnl add revd2 varchar2(4)';

Execute Immediate 'alter table '||touser||'.fjnl add revd3 varchar2(4)';

end proc_alter_xydTable;