Re: Are packages evil?

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Fri, 21 Jan 2005 10:55:59 -0800
Message-ID: <41f15031$1_2@127.0.0.1>

Fuzzy Greybeard wrote:

> 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

Thanks for the good laugh.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Fri Jan 21 2005 - 12:55:59 CST