Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why use Java Stored Procedures....

Re: Why use Java Stored Procedures....

From: Gerard H. Pille <ghp_at_skynet.be>
Date: Sat, 04 Mar 2006 13:45:34 +0100
Message-ID: <44098bdc$0$31480$ba620e4c@news.skynet.be>


Mladen Gogala wrote:
> On Wed, 01 Mar 2006 01:50:09 -0800, Miggins wrote:
>
>

>>OK short question but probably not a quick answer....anyone give me the
>>pros and cons of using Java for my stored proedures instead of PLSQL.
>>
>>Thanks In Advance

>
>
> PL/SQL mostly work while Java makes life interesting and makes your DBA
> think passionately about you, especially when he or she needs to allocate
> another petabyte of shared memory for Java pool, in addition to shared
> pool which cannot be avoided. Your DBA will love you for parsing XML
> files in memory and creating polymorphic object designs which have so
> little to do with database. Of course, access to Java pool is coordinated
> by latches, which will open completely new field of R&D and rid your DBA
> of boredom for months unend. You will really attract attention of all
> 3 of them: Smith, Wesson and DBA.
>

I dig this one. We have a poet in our midst. Received on Sat Mar 04 2006 - 06:45:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US