本文介绍了如何在Oracle中调用带有IN OUT参数的存储过程，强调了不能直接使用常量作为IN OUT参数的原因，并解释了IN OUT参数在调用时的特性，即传入传出值的机制。
定义了一个存储过程；
create or replace procedure FindBaseInfo(
v_id in out number,
v_name out varchar2,
v_title out varchar2
)
is
temp integer(2);
begin
select count(*) into temp from employee where id=v_id;
if temp>0 then
select id,name,title into v_id,v_name,v_title from employee where id=v_id;
dbms_output.put_line('succeed！');
else
v_id:=0;
dbms_output.put_line('failed！');
end if;
create or replace procedure FindBaseInfo(
v_id in out number,
v_name out varchar2,
v_title out varchar2
)
is
temp integer(2);
begin
select count(*) into temp from employee where id=v_id;
if temp>0 then
select id,name,title into v_id,v_name,v_title from employee where id=v_id;
dbms_output.put_line('succeed！');
else
v_id:=0;
dbms_output.put_line('failed！');
end if;
end;
调用过程如下：
最低0.47元/天 解锁文章
1346
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
