Java in Oracle Database Example

In this tutorial, I am giving an example to implement Java code in Oracle Database using the stored function. We can create Java programs in the Oracle database by using CREATE OR REPLACE AND COMPILE JAVA SOURCE statement. After that, we can refer that code in a stored function or a stored procedure with AS LANGUAGE JAVA clause. The following are the steps to implement Java in Oracle Database.

Java in Oracle Database Example

1. The following is the Java Hello World program example. First, we will add Java code using the CREATE OR REPLACE AND COMPILE AS JAVA SOURCE statement in Oracle database.

CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "Hello" AS
public class Hello
{
public static String World()
{
return "Hello World!";
}
};
/

2. Now create a stored function referring to the above Java program in Oracle database.

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

DECLARE
v_string VARCHAR2 (100 CHAR);
BEGIN
v_string := helloworld ();
END;
/

You can test it now:

SELECT helloworld FROM DUAL;

Output:

HELLOWORLD 
--------------------------
Hello World! 
1 row selected.

• Oracle For LOOP Select Statement Example
• How to Return ResultSet from Stored Procedure in Oracle
• How to create a Drop-Down list in Oracle Forms