简单的存储过程应用为后续准备

带有输入输出参数的存储过程
create or replace procedure inoutpara(no_in number,
                                       name_out out varchar2,
                                      salary out number)
is
begin
select name,sal into name_out,salary
from p
where no=no_in;
end inoutpara;
执行存储过程的步骤
var a varchar2(20);
var b number;
exec inoutpara(7369,:a,:b);

print a  b;