|
The following is a simple example of the usage of the Java stored procedure: create or replace and resolve java source named ExampleClass as public class ExampleClass { public static String changeToUpper(String str) { return str.toUpperCase(); } } / This creates a Java Source and a Java Class object. To access the method changeToUpper of this class, you need to write a wrapper function: create or replace function myupper (p_str in varchar2) return varchar2 as language Java name 'ExampleClass.changeToUpper(java.lang.String) return java.lang.String'; You can now use this function just like any other PL/SQL function. set serveroutput on declare l_str varchar2(30); begin l_str := myupper('example'); dbms_output.put_line(l_str); end; |