能否可以用java写一个发送mail的程序,然后在触发器中调用?调用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 createdSQL>
SQL> create or replace procedure run_helloworld
2 as language java
3 name 'HelloWorld.db_run()';
4 /Procedure createdSQL> set serveroutput on size 5000
SQL> call dbms_java.set_output(5000) ;Method calledSQL> exec run_helloworld ;Hello WorldPL/SQL procedure successfully completed
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 createdSQL>
SQL> create or replace procedure run_helloworld
2 as language java
3 name 'HelloWorld.db_run()';
4 /Procedure createdSQL> set serveroutput on size 5000
SQL> call dbms_java.set_output(5000) ;Method calledSQL> exec run_helloworld ;Hello WorldPL/SQL procedure successfully completed
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货