rem ----------------------------------------------------------------------- rem Filename: java.sql rem Purpose: Demonstrate Java stored procedures (available from Oracle 8i) rem Date: 13-Jun-2002 rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- conn / as sysdba -- @?/javavm/install/initjvm.sql grant javauserpriv to scott; conn scott/tiger prompt Loading java source into database... create or replace java source named "Hello" as public class Hello { /* Pure Java Code */ static public String Msg(String tail) { return "Hello " + tail; } } / -- SHOW ERRORS not needed -- Note, you can also use "loadjava" to load source files into Oracle. prompt Publish Java to PL/SQL... create or replace function hello (str varchar2) return varchar as language java name 'Hello.Msg(java.lang.String) return java.lang.String'; / show errors prompt Call Java function... select hello('Frank') from dual /