导入jar包和外部java代码
当导入Java文件时,可以用如下命令:
loadjava –u username/userpassword –v -resolve filename.java
|
当导入jar文件时,可以用如下命令:
loadjava –u username/userpassword –v -resolve filename.jar
|
创建function
create or replace function send_wechat(***,***,...) return 返回类型(eg:varchar2) is
language java name '包名.java类.方法名(***,***,...) return 方法的返回参数'
eg:
create or replace function send_wechat(AgentId varchar2,
Token varchar2
TradeType varchar2Title varchar2Descr varchar2UserIds varchar2nid varchar2urlstr varchar2) return varchar2 is
language java name 'nbcb.SendWeChat.sendMsg(java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,java.lang.String,)' return strdome
触发器中调用
*** := send_wechat(***,***,.....);