create or replace procedure pro_test(p_id in number,p_name out varchar2) as
begin
select name into p_name from tb_wtest where id = p_id;
end pro_test;
variable v_name varchar2(10);
execute pro_test(1003,:v_name);
print v_name;
oracle 11g 存储过程
最新推荐文章于 2021-12-22 16:44:24 发布