Oracle:调用程序包中的存储过程 [英] Oracle: Call stored procedure inside the package

问题描述

我对Oracle的了解不多.我使用PL/SQL Developer.

I'm not much in Oracle. I use PL/SQL Developer.

我有以下包裹:

create or replace package PKG1
as
procedure INIT
(
  nRN                       in number,
  nREC_TYPE                 in number,
  nIDENT                    out number
);

我不确定如何从PL/SQL Developer环境中调用它.我已经尝试过了:

I'm not sure how to call it from PL/SQL Developer environment. I've tried this:

DECLARE
  procId NUMBER;

BEGIN
  EXECUTE PKG1.INIT(1143824, 0, procId);
  DBMS_OUTPUT.PUT_LINE(procId);
END;

但是，存在ORA-06550(PLS-00103)错误.

But, there's an ORA-06550 (PLS-00103) error.

如您所见，我有2个输入和1个输出参数.我想打印输出参数.就是这样.

As you can see I have 2 input and 1 output parameter. I want to print out output parameter. That's all.

预先感谢您的帮助.

Goran

推荐答案

您已经快到了，只需取出EXECUTE:

You're nearly there, just take out the EXECUTE:

DECLARE
  procId NUMBER;

BEGIN
  PKG1.INIT(1143824, 0, procId);
  DBMS_OUTPUT.PUT_LINE(procId);
END;

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