java_sendmail.sql

用来JAVA存储过程在ORACLE9I或者10G里面发邮件的例子

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;