若是过程类型,可以设参数为in,out型,那同时作输入也改变参数后作输出.
create procedure name_pro(p_test in out varchar2)
as
begin
select ts into p_test from table where test=p_test;
end;
/
create procedure name_pro(p_test in out varchar2)
as
begin
select ts into p_test from table where test=p_test;
end;
/
上面的写法只能返回单值