[oracle] Oracle: Call stored procedure inside the package

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

I have the following package:

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

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;

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

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

Thanks in advance for help.

Goran

This question is related to oracle package

The answer is


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

DECLARE
  procId NUMBER;

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

Similar questions with oracle tag:

Similar questions with package tag: