create or replace procedure proc_tmp(unit in int,bianhao in string)
isbegin
select ........
from .........
where unit='||unit||' and bianhao=''||bianhao||'';
end;
isbegin
select ........
from .........
where unit='||unit||' and bianhao=''||bianhao||'';
end;
(pi_unit in integer,pv_bianhao in varchar2)
is
begin
.............
select ........
from .........
where unit=pi_unit and bianhao=pv_bianhao;
.............
end;