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

On 08 Apr 2003, pete_at_mynix.org wrote:

> The only problem, as I think I have measured, is the binding between
> the SQL engine and PL/SQL. Currently it seems like SQL is tighly bound
> to PL/SQL, and Java is wrapped into PL/SQL (see the way that Java
> Stored Procedures must be declared with "language java" in PL/SQL).

But Java's datatypes are java's datatypes. What you are saying is that Oracle should rewrite the internals of its storage structure so there won't be any need for a conversion to java's datatypes. It can tightly couple PL/SQL with SQL cause they are both Oracle's.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.