nidhi

• Nov 26th, 2007

 

Yes, we can have procedure in the specification but not in the package body. The use of this is that we can write any code in that procedure later on.

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Nov 26th, 2007

 

Thanks Nidhi for your reply...
But i think it is not possible,if you try to do this you will get error.....
and logically its fine,its Compilation error.....Its not in Specification but in body then its ok but vice-versa is not true.....

amahanit

 Profile Answers by amahanit Questions by amahanit

• Dec 1st, 2007

 

well if u write procedure only in body then its a private subprogram which can be accesed only by subprograms inside the package not from outside. 

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Dec 3rd, 2007

 

Yes thats true...It will be private.

raghu iyer

 Profile Answers by raghu iyer 

• Jul 11th, 2011

 

Hi,
Its Not possible..... all the sub programs declared in spec must be implemented in the body. In this case these sub programs will be private for this package only.

Raghu Iyer

Sudhanshu

• Jul 26th, 2016

 

Code
CREATE OR REPLACE PACKAGE Test_pkg AS


  2    PROCEDURE Proc1;


  3  END;


  4  /


 


PACKAGE created


 


CREATE OR REPLACE PACKAGE BODY Test_pkg AS


  2  


  3    PROCEDURE proc1 IS


  4    BEGIN


  5      proc2;


  6    END;


  7  


  8    PROCEDURE Proc2 IS


  9    BEGIN


 10      dbms_output.put_line(proc2 IS being executed);


 11    END;


 12  


 13  END;


 14  /


 


Warning: PACKAGE BODY created WITH compilation errors


Error: PLS-00313: PROC2 NOT declared IN this scope


 


This IS happening because we are calling Proc2 which declared later IN the PACKAGE. IN this CASE our choices are:


 


DECLARE pro2 before the PROCEDURE which calls it


 


 CREATE OR REPLACE PACKAGE BODY Test_pkg AS


  2  


  3  


  4    PROCEDURE Proc2 IS


  5    BEGIN


  6      dbms_output.put_line(proc2 IS being executed);


  7    END;


  8  


  9    PROCEDURE proc1 IS


 10    BEGIN


 11      proc2;


 12    END;


 13  


 14  END;


 15  /


 


PACKAGE BODY created


USE forward declaration.


 


CREATE OR REPLACE PACKAGE BODY Test_pkg AS


  2  


  3    PROCEDURE Proc2;


  4  


  5    PROCEDURE proc1 IS


  6    BEGIN


  7      proc2;


  8    END;


  9  


 10    PROCEDURE Proc2 IS


 11    BEGIN


 12      dbms_output.put_line(proc2 IS being executed);


 13    END;


 14  


 15  


 16  END;


 17  /


 


PACKAGE BODY created


 


SQL> EXEC test_pkg.Proc1;


 


proc2 IS being executed


 


PL/SQL PROCEDURE successfully completed

aak

• Sep 15th, 2016

 

No, You can add the proc in body and not declare it in the spec.. this is ok as it would mean that that proc is a private procedure but visa versa is not possible. It would give compilation error.