Re: Are packages evil?

From: Fuzzy Greybeard <Fuzzy.GreyBeard_at_Gmail.com>
Date: Fri, 21 Jan 2005 00:57:44 GMT
Message-Id: <pan.2005.01.21.00.57.41.797000@Gmail.com>

On Thu, 20 Jan 2005 09:22:52 +0100, 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?

Absolutely EVIL.

Stay away from them, unless you have professional environments (dev, test, prod), professional programmers and/or professional DBAs.

Do NOT use capabilities such as package loading and pinning;, do NOT use "session globals"; do NOT use overloading or private variables; do NOT deploy all parts of an application together.

Do NOT "CREATE OR REPLACE PACKAGE BODY" without a "CREATE OR REPLACE PACKAGE" when all you change is contents of the body.

Most importantly, do NOT learn about your tool set. Do NOT read chapter 9 of the "Application Developer's Guide - Fundamentals" manual or chapter 9 (especially the section titled "Advantages of PL/SQL Packages") of the "PL/SQL User's Guide and Reference Release 2 (9.2)" manual. Do NOT read books like ISBN: 1-59059-217-4 ...

lol/FGB Received on Thu Jan 20 2005 - 18:57:44 CST