Oracle Prozeduren mit Java schreiben

[Thomas Darimont]

Hallo!

Passendes Package anlegen:

 create or replace package de_tutorials_oracle_java_Test
 as
 function pi return number
 as
 language java 
 name 'de_tutorials_oracle_java_Test.pi() return double';
 end de_tutorials_oracle_java_Test;
 /

 create or replace and compile
 java source named "de_tutorials_oracle_java_Test"
 as
 public class de_tutorials_oracle_java_Test {
    public static double pi(){
 	  return Math.PI;
    }
 }
 /

Aufruf:

 SQL> select de_tutorials_oracle_java_Test.pi from dual;
 
 		PI
 ----------
 3,14159265

Gruß Tom