create or replace procedure pro_test (deal in number,error out varchar2) AS dealnum number(20); wd_id number(10); <--这个没用到 strsql varchar2(200); dd varchar2(200); begin dd:='tb_dept'; strsql:='select count(1) from '||dd||' where fd_dept_id='||deal; EXECUTE IMMEDIATE strsql into dealnum; <---修改这里和上句 error:=dealnum; end ;
AS
dealnum number(20);
wd_id number(10); <--这个没用到
strsql varchar2(200);
dd varchar2(200);
begin
dd:='tb_dept';
strsql:='select count(1) from '||dd||' where fd_dept_id='||deal;
EXECUTE IMMEDIATE strsql into dealnum; <---修改这里和上句
error:=dealnum;
end ;