oracle java类_oracle创建java类

研究了一下用plsql创建java类并调用，结果理想。

1、创建java类--创建java类

--DROP JAVA SOURCE "Hello"

create or replace and compile

java source named "Hello"

as

import java.lang.*;

public class Hello

{

public static String say(String args)

{

return args;

}

}

/

--Java created.

2、创建function调用java类--创建function

CREATE OR REPLACE FUNCTION Hello(message IN VARCHAR2) RETURN VARCHAR2 AS

LANGUAGE JAVA NAME 'Hello.say(java.lang.String) return String';

/

--Function created.

3、测试function--测试function

BEGIN

Dbms_Output.Put_Line(Hello('test ok!'));

EXCEPTION

WHEN OTHERS THEN

NULL;

END;

/

--test ok!

--PL/SQL procedure successfully completed