How to create a simple JAVA stored procedure? [Posting]

• Software environment:
  1. Operating System: Windows 2000 Server
  2. Data Base: Oracle 8i R2 (8.1.7) for NT Enterprise Edition
  3. installation path: C:/Oracle

• Implementation Method:

  1. Create a file named test. java public class test {public static void main (string ARGs []) {system. out. println ("Hello this is a Java procedure");} 2. javac test. java3, Java test4, SQL> conn system/managersql> grant create any directory to Scott; SQL> conn Scott/tigersql> Create or replace directory test_dir as 'd :/'; the directory has been created. SQL> Create or replace Java class using bfile (test_dir, 'test. class') 2/Java has been created. SQL> select object_name, object_type, status from user_objects; SQL> Create or replace procedure test_java as language Java name' test. main (Java. lang. string []) ';/the process has been created. SQL> set serveroutput on size 5000sql> call dbms_java.set_output (5000); call completed. SQL> execute test_java; Hello this is a Java procedure PL/SQL process has been completed successfully. SQL> call test_java (); Hello this is a Java procedure call completed.