Re: To package or not

A copy of this was sent to "Jim Poe" <jpoe_at_fulcrumit.com> (if that email address didn't require changing) On 17 May 2001 16:47:28 GMT, you wrote:

>This is general question about using packages. Should all procedures and
>functions be written in packages? Is there any reason not to put them into
>a package?
>
>Thanks

You should always use packages. Procedures are great for tiny exmaples but they stink in a real system.

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:286816015990

for the details but basically -- packages break the dependency chain, avoiding tons of cascading invalidations.  

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp