Question

Oracle 带输出参数的存储过程如何调用？

create or replace procedure total(minAge in number, maxAge in number, total out number) is
begin
select count(*) into total from person where age between minAge and maxAge;
end;
/
--调用方式一：
declare
count_ number;
begin
total(10, 30, count_);
dbms_output.put_line(count_);
end;
/

Answer 1

create or replace procedure detail_cs(a in number, b out number) is
begin
select 1+a into b from dual;
end detail_cs;
create or replace procedure call_test(a1 in number, b1 out number) is
begin
detail_cs(a1,b1);
end call_test;