PL/SQL calls Java code

1. Writing code directly in SQL developer

Create or replace and compile Java source named "HelloWorld"
As
Package com.test;

public class HelloWorld {
public static string SayHello (string name) {
Return "Hello::" + name;
}
}

2. Create a method or package call to JAVA

(1). method

Create or Replace function HelloWorld (p_name in varchar2) return varchar2as language Java name ' Com.test.HelloWorld.sayHel Lo (java.lang.String) return java.lang.String ';

(2). Package

--Baotou
Create or Replace package Phelloworld are  function Hello_world (p_name in varchar2) return varchar2;end phelloworld;--pack Body Create or Replacepackage body Phelloworld is  function Hello_world (p_name in varchar2) return varchar2 is    LANGUAG e Java name ' Com.test.HelloWorld.sayHello (java.lang.String) return java.lang.String '; end Phelloworld;

3. Calling a method or package, equivalent to calling Java

(1). Calling method

Begin    Htp.print (HelloWorld (' xx ')); end;

(2). Call Package

Begin    Htp.print (Phelloworld.hello_world (' xx ')); end;

Complete!

PL/SQL calls Java code