Re: java stored procedures fast, but slow when called as SQL function

From: <pete_at_mynix.org>
Date: 08 Apr 2003 15:14:40 +0200
Message-ID: <1049807679.1523.0@iapetus.uk.clara.net>

martin.chadderton_at_mwhglobal.com (Martin Chadderton) writes:

> > I was hoping to finally switch 100% to Java ISO PL/SQL, but this seems
> > to be impossible still :(
>
>
> Doesn't surprise me this, it's due to the SQL-oriented nature of what
> the JSP is trying to do. There's no better / more efficient language
> for handling SQL than PL/SQL.

What a pity that after 3 years (or more?) Oracle still didn't manage to get Java on par with PL/SQL w.r.t. integration with SQL. I cannot see a fundamental reason why it is not possible (especially with SQLJ and oracles propriatary extentions anything PL/SQL can should be possible in Java as well.

If Oracle wanted they could make Java just as suitable and efficient as PL/SQL. Received on Tue Apr 08 2003 - 08:14:40 CDT