Java 存储过程和触发器(24 )+汇.pptVIP

? Dr. Philip Cannata Data Management Java Stored Procedures Java Methods in Oracle Stored Procedure to Call Java Method Execute Stored Procedure Java Methods in Oracle Stored Procedure to Call Java Method Execute Stored Procedure Java Methods in Oracle Stored Procedure to Call Java Method Execute Stored Procedure Java Methods in Oracle Java Methods in Oracle Stored Procedure to Call Java Method Execute Stored Procedure Triggers Triggers Stored Procedure to Call Java Method Execute Stored Procedure Java Triggers Java Triggers Java Triggers Java Triggers Java TriggersThe Dreaded Mutating Table Problem Java Stored Procedures * First of all, always do this: set serveroutput on size 10000 call dbms_java.set_output(10000); If you get something like this ERROR at line 1: ORA-29549: class SCOTT.HelloWorld has changed, Java session state cleared ORA-06512: at SCOTT.HELLO, line 0 ORA-06512: at line 1 do this again call dbms_java.set_output(10000); Hello World method create or replace and compile java source named myProcedureMethods as public class myProcedureMethods { public static void helloWorld() { System.out.println(Hello world!); } } / hw stored procedure that calls the helloWorld java method. create or replace procedure hw as language java name myProcedureMethods.helloWorld(); / set serveroutput on size 10000 call dbms_java.set_output(10000); exec hw Simple JDBC method create or replace and compile java source named myProcedureMethods as import java.util.*; import java.sql.*; public class myProcedureMethods { public static void helloWorld() { System.out.println(Hello world!); } public static void simpleJDBC() throws SQLException { Connection conn = DriverManager.getConnection(jdbc:oracle:kprb:@); PreparedStatement pstatement = conn.prepareStatement(create or replace view empV1 as select * from emp); pstatement.executeQuery(); System.out.println(Created view empV1.); } } / sjdbc stored procedure that calls the si