oracle 11g 存储过程

create or replace procedure pro_test(p_id in number,p_name out varchar2) asbeginselect 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;