PL/SQL vs Java in 10gR2 and up

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Thu, 16 Sep 2010 17:42:59 -0400
Message-ID: <46732D8B0755664E87B4276E3C2FF60501A8D8F64AF7_at_EXM-OMF-06.Ceg.Corp.Net>

This has been a Tom Kyte maxim for a few quite some time. I'm wondering if it still holds true between PL/SQL and Java.
  1. Do it in SQL.
  2. If SQL can't do it, do it in PL/SQL.
  3. If PL/SQL can't do it, do it in Java.
  4. If Java can't do it ask yourself if it needs to be done.

As versions progress often there are enhancements which correct deficiencies of the past. Have such enhancements occurred to put Java on a more equal footing? Is PL/SQL still the best method for scripting/stored procedure writing?

In addition to a yes or no, could you add any specific advantages in terms of performance (vague, I know) that either one has over the other?

Mark Brady
Constellation Energy Group

>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1

Received on Thu Sep 16 2010 - 16:42:59 CDT

Original text of this message