Home » SQL & PL/SQL » SQL & PL/SQL » Package Specification
Package Specification [message #300863] Mon, 18 February 2008 06:25 Go to next message
Messages: 38
Registered: August 2005

I have got a package and a package body, where the specification of a procedure within the package body is not defined in the package. Curiously, the package body still compiles. Please can some tell me if this is standard in Oracle?

Re: Package Specification [message #300865 is a reply to message #300863] Mon, 18 February 2008 06:26 Go to previous messageGo to next message
Michel Cadot
Messages: 65084
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
yes, this is called private procedure and this is not an expert question but a basic PL/SQL one.

Re: Package Specification [message #300881 is a reply to message #300863] Mon, 18 February 2008 07:57 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
You created a procedure that can only be seen and called from within the package.
This is (and should be) used very often; you should only publish (i.e. declare in the package specification) those procedures, functions, cursors, types, etc that you want other packages to see. Stuff that is internal to that specific package should not be published.
Previous Topic: Can i edit/add to tnsnames.ora file with SQLPLUS?
Next Topic: selecting result of row that occurs more than 1.
Goto Forum:

Current Time: Fri Jul 21 20:17:46 CDT 2017

Total time taken to generate the page: 0.14803 seconds