oracle调用外部程序小例

例如：

调用java的存储过程：
SQL> create or replace and compile java source named HelloWorld
2 as
3 public class HelloWorld {
4 public static void db_run (){
5 System.out.println("Hello World";
6 }
7 }
8 /

Java created.


SQL> create or replace procedure run_helloworld
2 as language java
3 name 'HelloWorld.db_run()';
4 /

Procedure created.
SQL> set serveroutput on size 5000
SQL> call dbms_java.set_output(5000) ;

Call completed.

SQL>
SQL> exec run_helloworld ;
Hello World

PL/SQL procedure successfully completed.

你可以修改，使得HelloWorld类调用外部命令，而你的触发器调用过程 run_helloworld 。