Re: How to create an email with oracle

From: Snid <snid_at_snider.sno>
Date: Wed, 3 Dec 2003 10:36:22 +1000
Message-ID: <bqjb67$fgr$1@bunyip.cc.uq.edu.au>

Declare
 SendorAddress Varchar2(30) := 'somebody_at_usq.edu.au';  ReceiverAddress varchar2(30) := 'somebody_at_usq.edu.au';  EmailServer varchar2(30) := 'smtp.usq.edu.au';  Port number := 25;
 conn UTL_SMTP.CONNECTION;
 crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );  mesg VARCHAR2( 4000 );
 mesg_body varchar2(4000);
BEGIN
 conn:= utl_smtp.open_connection( EmailServer, Port );

 utl_smtp.helo( conn, EmailServer );
 utl_smtp.mail( conn, SendorAddress);
 utl_smtp.rcpt( conn, ReceiverAddress );

 mesg:=
'Date: '||TO_CHAR( SYSDATE, 'dd Mon yy hh24:mi:ss' )|| crlf ||
'From:'||SendorAddress|| crlf ||
'Subject: Mail Through ORACLE Database' || crlf ||
'To: '||ReceiverAddress || crlf ||
'' || crlf ||
' This is a test mail from Oracle Database' ;
 utl_smtp.data( conn, mesg );
 utl_smtp.quit( conn );
END;
/

"Lars Steinmetz" <lsteinmetz_at_nurfuerspam_jakrause.com> wrote in message news:1070363211.580688_at_news.thyssen.com...

| Hello NG,
|
| how can I create an email with oracle (9i standard edition) with a

trigger?

|
| Thanx
|

Received on Tue Dec 02 2003 - 18:36:22 CST