Question

如何执行带有输出参数书的oracle 存储过程！我是小白还请大神解答一下！ 输入的参数可以是‘家电’

create or replace procedure pro_out (v_catename IN VARCHAR2 ,v_categorid OUT NUMBER)

AS

BEGIN

SELECT categoryinfo.categoryid INTO v_categorid FROM categoryinfo
WHERE categoryinfo.categoryname=v_catename;

IF SQL%FOUND THEN
dbms_output.put_line('传出的参数是：'||v_categorid);
END IF;
END;

Answer 1

用语句块执行，为了看到输出结果，用dmbs_output将结果输出即可:
declare
v_result number;
v_name varchar2(200) := '家电';
begin
pro_out(v_name, v_result);
dbms_output.put_line('result is: ' || v_result);
end;