Home » RDBMS Server » Server Administration » calling Java methods from Oracle
calling Java methods from Oracle [message #56105] Thu, 06 March 2003 04:34 Go to next message
manohar
Messages: 15
Registered: October 2001
Junior Member
Hi all

I have a database on Oracle 8.1.6 JServer Release
what are the steps involved in calling java classes in oracle

Manohar
Re: calling Java methods from Oracle [message #56106 is a reply to message #56105] Thu, 06 March 2003 05:16 Go to previous message
Remi Visser
Messages: 44
Registered: December 2002
Member
You need to make a wrapper function that maps the function in (and out) parameters with the java parameters return types:

This is from metalink:

CREATE OR REPLACE JAVA SOURCE NAMED "Fokke" 

AS
       
   public class Hello 
   {                                                          
      public static String hello() 
      {
      
         return "Hello World";

      }
   }
   ;
/

This will create 2 db objects:

The JAVA SOURCE object will be stored as plain text (the java source code) and 
   the JAVA CLASS will be stored as the compiled java code.

[jav@db1.ben.nl] SELECT object_name, object_type FROM user_objects;

OBJECT_NAME                         OBJECT_TYPE
---------------------------------------------------
Fokke                               JAVA SOURCE
Hello                               JAVA CLASS

Create a wrapper, callspec clause:

CREATE OR REPLACE FUNCTION call_Fokke 
   RETURN VARCHAR2
   AS 
   LANGUAGE JAVA 
       NAME 'Hello.hello() return java.lang.String'
   ;
/

SELECT call_Fokke FROM DUAL;

Hope this helps

remi

http://askremi.ora-0000.com
Previous Topic: ORA-01092: ORACLE instance terminated. Disconnection forced
Next Topic: compress
Goto Forum:
  


Current Time: Fri Sep 20 07:30:49 CDT 2024