Live ORACLE

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
/

Demonstrate Java stored procedures