Re: Q: Java stored procedures

A copy of this was sent to bonanos_at_yahoo.com (if that email address didn't require changing) On Fri, 21 May 1999 08:09:29 GMT, you wrote:

>Hi
>
>> Can you call a java stored procedure from Oracle
>> Forms/Reports applications (5.0/3.0 or above)? What
>> are the performance impact or any other difference of
>> using java stored procedures vs. pl/sql stored procedures?
>
>I've heard it mentioned that java stored procedures should be faster
>than Pl/SQL when you are doing computional expensive work as opposed to
>database access and vica verca.
>
>IMO I can't see an advantage of using java stored procedure generally
>speaking.
>
>And from what I here, to create and edit java stored procs is not as
>easy as PL/SQL ones.
>
>Also a question I am interested in is if the java in the database is
>natively compiled or does it go the usual java root of being complied as
>it is.
>

in 8.1.5, code you develop is stored in byte code and interpreted as normal.

The exists a ncomp compiler tho that turns java into c, compiles the c into object code and we run that. we use that for our internal packages in 8.1.5 and the intention is to release that for 8.1.6 so you can too.

>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---

See http://www.oracle.com/ideveloper/ for my column 'Digging-in to Oracle8i'...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA

--
Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Fri May 21 1999 - 12:47:28 CDT