Re: Enterprise OpenSource Project using Java Stored Procedures of Oracle

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 03 Aug 2004 13:24:09 GMT
Message-ID: <ZlMPc.205076$IQ4.157952_at_attbi_s02>


"Suresh Tri" <trisuresh_at_yahoo.co.in> wrote in message news:a8de98e.0408030140.7464f470_at_posting.google.com...
> Hi all,
>
> I am in search of any Enterprise level Opensource Project that uses
> Java Stored Procedures supported by Oracle. I could not find any by
> googling. Can any one plese point me to any such projects?
>
> Actually i'm intereseted in knowing to what extent java stored
> procedures are used in enterprise applications. A opensource project
> will let me look into the code to get better idea.
>
> Please help,
>
> Thanks,
> Suresh
People only use Java stored procedures in Oracle if the stored procedure needs to do something pl/sql cannot do or it is very clumsy to do. There isn't any reason to use Java stored procedures if you can reasonably do it in pl/sql. Why? Because it is harder to do in Java things that are easy to do in pl/sql, so only a language bigot would do such a thing. Jim Received on Tue Aug 03 2004 - 15:24:09 CEST

Original text of this message