Re: Q: Java stored procedures

From: <bonanos_at_yahoo.com>
Date: Fri, 21 May 1999 08:09:29 GMT
Message-ID: <7i34bp$de1$1@nnrp1.deja.com>

> 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.

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 03:09:29 CDT