Java Stored Procedures...any thoughts?

From: Michael P. McCutcheon <michaelm_at_value.net>
Date: Wed, 23 Aug 2000 20:38:14 -0700
Message-ID: <8o252b$7bg$1@news.value.net>

Our organization is thinking about using Java stored procedures in Oracle 8i because we don't have enough PL/SQL people, and the Java (middle tier) developers want to take things into their own hands. We need to do this because we have a lot of database intensive work that might be better done on the back end.

Questions:

What do you need to create and deploy a Java stored procedure (i.e. Do you need the JDeveloper package from Oracle, or can you just use the JDK and a text editor?)
What are your experiences with using Java Stored Procedures? Good, bad, ugly?
Are there any advantages to using Java Stored Procedures over PL/SQL stored procedures?
Is the API the for stored procedures the same as the JDBC API?

Any thoughts or suggestions would be greatly appreciated (please copy my email when responding to the newsgroup).

Mike Received on Wed Aug 23 2000 - 22:38:14 CDT