Oracle Call stored procedure inside the package

Question

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

User · Answer

To those that are incline to use GUI   Click Right mouse button on procecdure name then select Test    Then in new window you will see script generated just add the parameters and click on Start Debugger or F9    Hope this saves you some time

User · Answer

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] Oracle: Call stored procedure inside the package

Examples related to oracle

Examples related to package