我有一个存储过程,其 IN OUT 参数声明如下:
create or replace PROCEDURE RIFATT_SEGN0_INS(pIdRifattSegn0 in OUT NUMBER,
pNumDossier IN VARCHAR2 ,
pNumConsegna IN NUMBER,
pDtConsegna IN DATE,
[..]
) AS
[..]
每当我从另一个过程调用它时,如何获取也已退出的 pIdRifattSegn0 参数?
你的问题并不完全清楚。顾名思义,IN OUT 参数是双向传递的。这意味着它必须传递一个变量,而不是一个文字,并且您需要一个声明块来做到这一点。例如:
declare
l_segn number;
begin
l_segn := 1;
-- procedure will have received value = 1
rifatt_segn0_ins(l_segn, 'x', 2, sysdate);
-- procedure may have changed value of l_segn from 1 to something else
dbms_output.put_line(l_segn);
end;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)