全部博文
-
编辑 删除
send mail using PL/SQL and the database trigger monitoring the error
I think it's useful, later, i will enhance it[@more@]CREATE OR REPLACE PROCEDURE send_mail (pSender VARCHAR2,pRecipient VARCHAR2,pSubject VARCHAR2,pMessage VARCHAR2) ISmailhost CONSTANT VARCHAR2(30) := 'wzccb.com';crlf CONSTANT VARCHAR2(2):= CHR(13) || CHR(10);mesg VARCHAR2(1000);mail_conn utl_smtp.connection;BEGIN mail_conn := utl_smtp.open_connection(mailhost, 25); mesg := 'Date: ' || TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss') || crlf || 'From: <'|| pSe
