Re: saving emails in an Oracle table

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 03 Feb 2010 15:48:07 +0100
Message-ID: <4b698ca4$0$22938$e4fe514c_at_news.xs4all.nl>

Op 3-2-2010 10:05, Frank van Bortel schreef:
> Shakespeare wrote:
>> Op 31-1-2010 11:13, Frank van Bortel schreef:
>>> Shakespeare wrote:
> [snip!]
>>>> Shakespeare
>>> That's right; but only outgoing. Never managed incoming mail.
>>> And it can only handle outgoing mail when connected to an email
>>> relay
>>>
>>
>> I think utl_smtp does not need a relay server. But you're right: it
>> does not receive mail.
>>
>> Shakespeare
>
> Well, this is how I start - note the smtp_host and ~port:
>
> FUNCTION begin_session RETURN utl_smtp.connection IS
> conn utl_smtp.connection;
> BEGIN
> -- open SMTP connection
> conn := utl_smtp.open_connection(g_smtp_host, g_smtp_port);
> utl_smtp.helo(conn, g_smtp_domain);
> RETURN conn;
> END;
You're right... I had some examples where the mail server is the local (database) host itself (having a mail server service installed), but technically that is still a relay...

Shakespeare Received on Wed Feb 03 2010 - 08:48:07 CST