4.建立packages,此处为演示方便,我将java proc成了function,从实用角度考虑,应该是映射成普通的procedure更常用些,大家根据自己情况建吧
[PHP]
create or replace package Java_Sendmail as
/**
* 向指定地址发邮件
* @param to String
* @param sendTopic String
* @param sendContent String
* @param ishtml int
* @return String
*/
function send(strTo In Varchar2,
strTopic In Varchar2,
strContent In Varchar2,
isHtml in number) return varchar2;
/**
* 向指定地址发邮件,有附件
* @param to String
* @param sendTopic String
* @param sendContent String
* @param strFilename String
* @param ishtml int
* @return String
*/
function send(strTo In Varchar2,
strTopic In Varchar2,
strContent In Varchar2,
strFilename In varchar2,
isHtml in number) return varchar2;
/**
* 向指定地址发邮件,有抄送,有密送
* @param to String
* @param strcc String
* @param strbcc String
* @param sendTopic String
* @param sendContent String
* @param ishtml int
* @return String
*/
function send(strTo In Varchar2,
strcc in varchar2,
strbcc in varchar2,
strTopic In Varchar2,
strContent In Varchar2,
isHtml in number) return varchar2;
/**
* 向指定地址发邮件,有抄送,有密送,有附件
* @param to String
* @param strcc String
* @param strbcc String
* @param sendTopic String
* @param sendContent String
* @param strFilename String
* @param ishtml int
* @return String
*/
function send(strTo In Varchar2,
strcc in varchar2,
strbcc in varchar2,
strTopic In Varchar2,
strContent In Varchar2,
strFilename In varchar2,
isHtml in number) return varchar2;
end Java_Sendmail;
create or replace package body Java_Sendmail as
function send(strTo In Varchar2,
strTopic In Varchar2,
strContent In Varchar2,
isHtml in number) return varchar2 as
LANGUAGE JAVA NAME 'MailSender.send(java.lang.String,
java.lang.String,
java.lang.String,
int) return java.lang.String';
function send(strTo In Varchar2,
strTopic In Varchar2,
strContent In Varchar2,
strfilename In varchar2,
isHtml in number) return varchar2 as
LANGUAGE JAVA NAME 'MailSender.send(java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
int) return java.lang.String';
function send(strTo In Varchar2,
strcc in varchar2,
strbcc in varchar2,
strTopic In Varchar2,
strContent In Varchar2,
isHtml in number) return varchar2 as
LANGUAGE JAVA NAME 'MailSender.send(java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
int) return java.lang.String';
function send(strTo In Varchar2,
strcc in varchar2,
strbcc in varchar2,
strTopic In Varchar2,
strContent In Varchar2,
strfilename In varchar2,
isHtml in number) return varchar2 as
LANGUAGE JAVA NAME 'MailSender.send(java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
java.lang.String,
int) return java.lang.String';
end Java_Sendmail;
--
[/PHP]