PL/SQL or SQL in the middle tier?

From: The House Dawg <mhousema_at_ix.netcom.com>
Date: Wed, 20 Feb 2008 11:10:52 -0800 (PST)
Message-ID: <986bc0a3-9eb7-461d-bcb1-125726dd45f5@u69g2000hse.googlegroups.com>

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 Received on Wed Feb 20 2008 - 13:10:52 CST

This message: [ Message body ]
Next message: joel garry: "Re: Recover from cold backup + archive logs question"
Previous message: Ben: "Re: Out of control TEMP tablespace"
Next in thread: Steve Howard: "Re: PL/SQL or SQL in the middle tier?"
Reply: Steve Howard: "Re: PL/SQL or SQL in the middle tier?"
Reply: fitzjarrell_at_cox.net: "Re: PL/SQL or SQL in the middle tier?"
Reply: Andrew M: "Re: PL/SQL or SQL in the middle tier?"
Reply: The House Dawg: "Re: PL/SQL or SQL in the middle tier?"
Reply: joel garry: "Re: PL/SQL or SQL in the middle tier?"
Reply: William Robertson: "Re: PL/SQL or SQL in the middle tier?"
Reply: pav930t_at_gmail.com: "Re: PL/SQL or SQL in the middle tier?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message