Oracle存储过程的OUT参数 [英] Oracle stored procedure OUT parameters

问题描述

我有一个存储过程，其中的IN OUT参数声明如下:

I have a stored procedure with an IN OUT parameter declared like follows:

create or replace PROCEDURE RIFATT_SEGN0_INS(pIdRifattSegn0  in  OUT NUMBER,
                           pNumDossier IN VARCHAR2 ,
                           pNumConsegna IN NUMBER,
                           pDtConsegna IN DATE,
[..]

)  AS
[..]

每当我从另一个过程调用它时，如何获取也没有显示的pIdRifattSegn0参数?

Whenever i call it from another procedure, how do i get the pIdRifattSegn0 parameter that is also out?

推荐答案

您的问题尚不完全清楚.顾名思义，IN OUT参数是双向传递的.这意味着必须将其传递给变量而不是文字，并且您需要一个声明块来执行此操作.例如:

Your question isn't entirely clear. An IN OUT parameter is passed both ways, as its name implies. This means it has to be passed a variable, not a literal and you need a declare block to do that. For example:

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;

这篇关于Oracle存储过程的OUT参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！