Creating Oracle Stored Procedure using Java
Did you know you can write Oracle database stored procedure in Java? Give this a try in your
sqlplus prompt.
sql> create or replace and compile java source named "MyJavaDbProcedure" as
sql> public class MyJavaDbProcedure {
sql> public static String upcase(String text) {
sql> return text.toUpperCase();
sql> }
sql> };
sql> /
sql>
sql> create or replace function upcase (s in varchar2)
sql> return varchar2
sql> as language java
sql> name MyJavaDbProcedure.upcase(java.lang.String) return java.lang.String;
sql> /
sql>
sql> select upcase(hello) from dual;
sql> /
I let the database compile a Java source directly, but there is also the java class PL/SQL that you can load Java binary .class file as well. I am sure your DBA will fight all their might to prevent you doing stuff like this. But its cool to see that this option is available.
alternative link download
