1. 创建Java Stored Procedure

createorreplaceandcompilejavasourcenamed"TestHello"aspublicclassTestHello{publicstaticvoidtest(){System.out.println("Hello");}}


2.创建JSP调用存过或方法（本例为在包创建的存过）

createorreplacepackagepkg_testisproceduredo_Test;endpkg_test;/createorreplacepackagebodypkg_testisproceduredo_Testaslanguagejavaname'TestHello.test()';beginnull;endpkg_test;/

3.在命令窗口调用，通过如下命令使System.out重定向到当前窗口

SQL>setserveroutputonSQL>calldbms_java.set_output(5000);MethodcalledSQL>execpkg_test.do_Test;HelloPL/SQLproceduresuccessfullycompleted