Re: Package with no body

astalavista wrote:
> Hi,
>
> I have a package with no body associated,
> but the package works (Oracle 9.2.0.6)
> how is it possible ?
>
> Thanks in advance

Possible? It is common.

SQL> SELECT object_type, COUNT(*)

   2 FROM dba_objects
   3 WHERE object_type LIKE 'PACKAGE%'
   4 GROUP BY object_type;

OBJECT_TYPE COUNT(*)

------------------- ----------
PACKAGE                    851
PACKAGE BODY               795

Package headers are used to define constants, variables, exceptions, and data types. No package body is used or required.

You can find demos of this functionality in Morgan's Library at www.psoug.org under PACKAGES, USER DEFINED.

Likely there are other things about packages of which are unfamiliar so also look up PRAGMA SERIALLY_REUSABLE and the INITIALIZATION section.

HTH

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org