Question

在plsql 里如何执行存储过程。存储过程是正确地。我试过了。

create or replace procedure count_num(sex in char, num out number)
as
begin
if(sex='男') then
select count(xb) into num from test where xb='男';
else
select count(xb) into num from test where xb='女';

end if;
end count_num;

Answer 1

DECLARE
v_num number
BEGIN
count_num( '男', v_num);
dbms_output.put_line('v_num=' || TO_CHAR(v_num));
END

Answer 2

file new 一个sqlwindow 写
call 存储过程名（）；括号里 有参数就写参数 没有就不写。