PLSQL中有返回值的存储过程

存储过程&＃xff1a;

CREATE OR REPLACE PROCEDURE stu_proc(v_name IN VARCHAR2 DEFAULT &＃39;张三&＃39;, v_id OUT NUMBER) AS
--声明语句段
BEGIN--执行语句段SELECT id INTO v_id FROM student where sname&＃61;v_name;EXCEPTION--异常处理语句段WHEN NO_DATA_FOUND THEN
dbms_output.put_line(&＃39;NO_DATA_FOUND&＃39;);
END;
调用&＃xff1a;

DECLAREi NUMBER ;
BEGINstu_proc(&＃39;张三&＃39;,i);dbms_output.put_line(&＃39;查询到的ID为&＃xff1a; &＃39;||i);
END;结果&＃xff1a;