Re: Package vs standalone for single function/procedure?

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.

>