declare
l_routin varchar2(100) := 'gen2161.get_rowcnt';
l_tblnam varchar2(20) := 'emp';
l_cnt number;
l_status varchar2(200);
begin
execute immediate 'begin ' || l_routin || '(:2, :3, :4); end;'
using in l_tblnam, out l_cnt, in out l_status; if l_status != 'OK' then
dbms_output.put_line('error');
end if;
end;(:2, :3, :4)是什么意思?
using in l_tblnam, out l_cnt, in out l_status 是什么意思?
l_routin varchar2(100) := 'gen2161.get_rowcnt';
l_tblnam varchar2(20) := 'emp';
l_cnt number;
l_status varchar2(200);
begin
execute immediate 'begin ' || l_routin || '(:2, :3, :4); end;'
using in l_tblnam, out l_cnt, in out l_status; if l_status != 'OK' then
dbms_output.put_line('error');
end if;
end;(:2, :3, :4)是什么意思?
using in l_tblnam, out l_cnt, in out l_status 是什么意思?
使用 using 后面的变量,按顺序代替
也就是说 :2 = l_tblnam, :3 = l_cnt, :4 = l_status