Re: Package vs standalone for single function/procedure?

Hi Jonathan

Regrettably my experiences with packages, both in 7.3 and 8i, are different. Maybe this is a Toad issue, but if I change the body only and compile it, *all* dependent code becomes invalid. Needless to say, this is a pita.

Regards,

Sybrand Bakker, Oracle DBA

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:978621445.24660.1.nnrp-08.9e984b29_at_news.demon.co.uk...
>
> And there is (at least) one good reason for putting a
> single function or procedure into a package - other
> functions, procedures or packages may depend on it.
>
> If you rewrite a standalone function/procedure,
> anything that depends on it becomes invalid
> and has to be recompiled.
>
> If you rewrite a packaged function you only
> recompile the package body, so the package
> specification never becomes invalid, so all
> the dependent objects remain valid.
>
>
> --
> Jonathan Lewis
> Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
>
> Practical Oracle 8i: Building Efficient Databases
>
> Publishers: Addison-Wesley
> See a first review at:
> http://www.ixora.com.au/resources/index.htm#practical_8i
> More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html
>
>
>
> Keith Jamieson wrote in message <9322qm$3ti$1_at_kermit.esat.net>...
> >
> >So, it is not really sensible to put just one function or procedure into
 a
> >package, unless you have some other good reason to do so.
> >
>
>
>
Received on Sat Jan 06 2001 - 02:04:04 CST