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 。