Need a Defense for SPs

From: Jimmy Bond <deeachem_at_netscape.net>
Date: Wed, 27 Feb 2002 19:44:06 -0500
Message-ID: <a5jukb$chq$1@slb3.atl.mindspring.net>

A group at my company is trying to ban the use of Stored Procedures. Why? Well, these are the reasons that they cite for banning SPs:

In the past, some projects in which a database needed to either be retired or migrated had problems doing this due to hundreds of unmanaged and undocumented stored procedures that had built up over time (NOTE: This occurred with some Sybase databases that were being migrated to Oracle)
To keep application logic out of the data tier
Because the company has no release management policies, guidelines or automation for stored procedures
A company plan to build a Business Rules Engine sometime in the future
To help future portability of the database to another platform (presumably DB2)

Yeah, I know this group's reasoning probably sounds like something out of a Dilbert cartoon, but I need more reasons than simply calling the group techically incompetent to defend SPs and try to keep them from establishing this as a company policy.

Can anyone give some great reasons why SPs should be allowed, and even encouraged, in a development environment? (BTW, our projects' front-end apps are usually Java or C++ based, sometime with a Mid-Tier Application layer)

(Thanks in Advance) Received on Wed Feb 27 2002 - 18:44:06 CST