Re: Why use Java Stored Procedures....

From: Ed Prochak <edprochak_at_gmail.com>
Date: 1 Mar 2006 13:16:26 -0800
Message-ID: <1141247786.073575.14180@z34g2000cwc.googlegroups.com>

Gerry Atric wrote:
> 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.
>
>
>
> CON: PL/SQL is 100% Oracle-centric while Java is not. If you ever want to
> migrate your apps away from Oracle for some reason, keep in mind that all
> of your PL/SQL code will have to be ported too. My personal rule of thumb,
> anything I develop in PL/SQL I do with the assumption that it will never be
> ported in the future.

So how many other databases support JAVA for stored procedures? Wasn't ORACLE the first. Received on Wed Mar 01 2006 - 15:16:26 CST