Re: Are packages evil?

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 20 Jan 2005 15:58:36 -0800
Message-ID: <1106265516.095136.219140@c13g2000cwb.googlegroups.com>

Heinz Zastrau wrote:
> Hello,
>
> I start with a new project and want to uses packages, but are
packages
> evil?
>
> What is happend when many clients use routines of the package and I
want
> to change one (not used at the moment) and get a compile error? Are
all
> client calls against this package fail? If yes, then I think packages
are
> not useable in living (growing) application. :-(
>
> What are your opinions?
>
> --
> Ciao Heinz Z.

Like others mentioned, you cannot blame packages if your code deployment and change management policy is incorrect. Secondly, you will come to realize the significance of packages when you start working with a big application like an ERP. Packages result in manageable code in few hundred objects rather then few thousand procedures, functions etc.
Far from being evil... packages are actually one of the most important features offered by Oracle that is not offered in e.g. SQL Server. Regards
/Rauf Received on Thu Jan 20 2005 - 17:58:36 CST