Re: PL/SQL or SQL in the middle tier?

From: William Robertson <>
Date: Thu, 21 Feb 2008 00:24:55 -0800 (PST)
Message-ID: <>

On Feb 20, 7:10 pm, The House Dawg <> wrote:
> Folks,
> I work for a Fortune 50 company and we currently have millions of PL/
> SQL code in production. Recently, there has been an initiative
> launched by our DBA's to have software engineers move the PL/SQL out
> of the database and move it into the middle tier.
> Does this make sense to anyone? I realize that SOX could be playing a
> part in this because it's difficult to debug a production issue when
> developers must be granted temporary execute privilege on the various
> stored procedures and stored functions to debug the issue.

Obviously this is a stupid idea. There is inevitably tension between database and middle tier groups (assuming they are different groups in your organisation), with the middle tier teams typically outnumbering database developers, knowing or caring little about databases and convinced they should get the work and we should quit. At my last such job somebody discovered that there was a nanosecond overhead in calling a stored procedure compared to calling a query directly. Of course all the MT guys heard was "embedded is faster", never mind the fact that very few procedures contained just a single query and any infinitesimal advantage was quickly lost for multiple calls, never mind that PL/SQL is *easier* for a database developer to access, maintain, debug and tune, and so on. Feebly invoking SOX makes no sense either but I guess some people will try anything. Good luck in getting a new job. Received on Thu Feb 21 2008 - 02:24:55 CST

Original text of this message