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

On Feb 6, 2:32 pm, "astalavista" <nob...@nowhere.com> 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

How would anyone know without seeing your code? Post it and possibly
an answer will appear.


David Fitzjarrell

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@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org