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

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Thu, 21 Feb 2008 03:23:31 -0800 (PST)
Message-ID: <8a0e341d-6d49-4569-ba40-a814de3fec0a@62g2000hsn.googlegroups.com>


On Feb 20, 4:25 pm, The House Dawg <mhous..._at_ix.netcom.com> wrote:
> On Feb 20, 11:10 am, The House Dawg <mhous..._at_ix.netcom.com> 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.
>
> > I can think of many reasons *NOT* to do this.
>
> > TIA for any and all feedback.
>
> > Matt
>
> Oops, I left out the proposed refactoring - the software engineers
> would translate the PL/SQL into SQL that would be embedded into
> our .Net (C#) middle tier. The database layer would just be a set of
> tables that the middle tier would manipulate with SQL.

I would still be interested to hear what the DBA's reasons were for suggesting this. Received on Thu Feb 21 2008 - 05:23:31 CST

Original text of this message