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

From: Nuno Souto <wizofoz2k_at_yahoo.com.au>
Date: 13 Apr 2003 18:42:39 -0700
Message-ID: <73e20c6c.0304131742.43df0662@posting.google.com>

hjp-usenet_at_hjp.at (Peter J. Holzer) wrote in message news:<slrnb9jjfm.sgj.hjp-usenet_at_teal.hjp.at>...
> >
> > Not really. A virtual machine is MUCH more than just a runtime
> > interpreter.
>
> Actually, no. A virtual machine is an interpreter. No more, no less.
>

Let's agree to disagree on this one.

>
> It is possible that Oracle decided to run the JVM in a different
> process.

In common with just about every other supplier in the same situation.

> It's a rather strange, though, as the JVM was designed
> to be embeddable.

Yes, but is it practical? IOW, if Sun delivers a new JVM, do you think Oracle is gonna re-release it's own embedded version and risk no-one upgrading it?

>
> Quite similar to some PL/SQL packages like UTL_FILE.
>

Don't know the details of UTL_FILE nowadays. It changed a few times in the last releases.

Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam Received on Sun Apr 13 2003 - 20:42:39 CDT