?? java_sendmail.sql
字號:
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;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -