깨비네 마을 ~ 'ㅁ'/

오라클을 이용한 이메일 보내기 create or replace package PA_SEND_EMAIL is gn_err_no number; gs_err_msg varchar2(200); PROCEDURE sp_send_email( P_fromemail IN VARCHAR2, P_toemail IN VARCHAR2, P_subject IN VARCHAR2, P_body IN VARCHAR2); FUNCTION sf_send_email( parm_gbn char ) return varchar2 ; PRAGMA RESTRICT_REFERENCES (sf_send_email, WNDS); end PA_SEND_EMAIL; / create or replace package body PA_SEND_EMAIL is ..

CREATE OR REPLACE PROCEDURE SP_SEND_EMAIL( P_fromemail IN VARCHAR2 , P_toemail IN VARCHAR2 , P_subject IN VARCHAR2 , P_body IN VARCHAR2 ) IS l_boundary VARCHAR2(50) := '----=*#abc1234321cba#*='; v_From VARCHAR2(80) := P_fromemail||'@xxx.com'; v_Recipient VARCHAR2(80) := P_toemail||'@xxx.com'; v_Subject VARCHAR2(80) := P_subject; v_Mail_Host VARCHAR2(30) := 'xx.co.kr'; v_Mail_Conn utl_smtp.Connec..

[ 오라클에서 이메일 보내기 ] - UTL_SMTP.write_data를 이용할 경우 한글이 지원되지 않음 create or replace procedure SP_SEND_EMAIL(send_email varchar2, receiver_email varchar2, title_email varchar2 , message_email varchar2) is begin declare v_From varchar2(80) := send_email||'@xx.co.kr'; v_Recipient varchar2(80) := receiver_email||'@xx.co.kr'; v_Subject varchar2(80) := title_email; v_mail_host varchar2(30) := 'mail.xx.co.kr..

[ 쿼리 내용을 CSV로 첨부파일 만들어서 이메일 보내기 ] CREATE OR REPLACE PROCEDURE PROC_MAGAM_EMAIL_SEND(P_WORK_DATE VARCHAR2, P_TO_EMAIL VARCHAR2) IS BEGIN DECLARE i NUMBER := 1; p_to VARCHAR2 (100) := P_TO_EMAIL; -- 받는사람 lv_smtp_server VARCHAR2 (100) := 'mail.xx.co.kr'; -- 메일서버주소 lv_from VARCHAR2 (100) := 'ppp@xx.co.kr'; -- 보내는사람 v_connection UTL_SMTP.connection; c_mime_boundary CONSTANT VARCHAR2 (256) := '--AAAAA..