CODEWITHSUNDEEP
oracle-databasepackage
tesicg
tesicg

Reputation: 4053

Oracle: Call stored procedure inside the package

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.

Upvotes: 22

Views: 161967

Answers (2)

Matas Vaitkevicius
Matas Vaitkevicius

Reputation: 61401

To those that are incline to use GUI:

Click Right mouse button on procecdure name then select Test

enter image description here

Then in new window you will see script generated just add the parameters and click on Start Debugger or F9

enter image description here

Hope this saves you some time.

Upvotes: 8

cagcowboy
cagcowboy

Reputation: 30848

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

DECLARE
  procId NUMBER;

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

Upvotes: 40

Related Questions