Re: How can I access java procedures from PL/SQL (sqlplus) in 9i

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 7 Oct 2002 12:23:26 -0700
Message-ID: <92eeeff0.0210071123.73dac915@posting.google.com>

tloim_at_yahoo.com (E. Taner Tumer) wrote in message news:<bd35512e.0210062300.5658af2a_at_posting.google.com>...
> Hi,
>
> I want to use some of the builtin java classes in my PL/SQL functions.
> Can it be possible? If so would you please send me some sample code
> written in PL/SQL.
>
> Thanks,

Make sure JVM is installed in Oracle database. To find out, login as SYS and run SQL> select count(*) from user_objects where object_name like 'JAVA%'; If count is 6000 +, then it is installed.

Here is a sample code that you can use,

• Java source CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "HelloWorld" AS public class HelloWorld { public static String hello () throws Exception {

         return "Hello World";
      }

   }
/

• PL/SQL Wrapper CREATE OR REPLACE FUNCTION Hello_World RETURN VARCHAR2 AS LANGUAGE JAVA NAME 'HelloWorld.hello() return java.lang.String'; /

SQL> select Hello_World from dual;

HELLO_WORLD

---

Hello World

/Rauf Sarwar Received on Mon Oct 07 2002 - 14:23:26 CDT