Shulou(Shulou.com)06/01 Report--

1. Create Java Stored Procedure

Create or replace and compile java source named "TestHello" aspublic class TestHello {public static void test () {System.out.println ("Hello");}}

two。 Create a JSP that calls the saved or method (in this case, the saved one created in the package)

Create or replace package pkg_test is procedure do_Test;end pkg_test;/create or replace package body pkg_test is procedure do_Test as language java name 'TestHello.test ()'; begin null;end pkg_test;/

3. Called in the command window, redirect System.out to the current window with the following command

SQL > set serveroutput onSQL > call dbms_java.set_output (5000); Method calledSQL > exec pkg_test.do_Test;HelloPL/SQL procedure successfully completed

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.