Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: [PL/SQL] Replacing single procedure in a package?
Martin Doherty wrote:
> Every package consists of one or two parts: a header/specification
> (CREATE OR REPLACE PACKAGE) and an optional body (CREATE OR REPLACE
> PACKAGE BODY). If the package header only declares data (variables,
> constants, types) then no body is needed. If the package header declares
> any procedures or functions then a body is needed to define the code for
> those program units.
<snip>
In this case, true, but not in general.
A package header may exist without body. Not vice versa.
Package headers can be used to define defaults in (large) development
projects (large being > 3, probably), to enforce standards.
Quite helpful.
Frank Received on Tue Jan 14 2003 - 14:30:29 CST