Re: [PL/SQL] Replacing single procedure in a package?
From: Frank <fvanbortel_at_netscape.net>
Date: Tue, 14 Jan 2003 21:30:29 +0100
Message-ID: <3E247365.3040608_at_netscape.net>
Date: Tue, 14 Jan 2003 21:30:29 +0100
Message-ID: <3E247365.3040608_at_netscape.net>
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 - 21:30:29 CET