Re: saving emails in an Oracle table

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sat, 30 Jan 2010 10:58:57 +0100
Message-ID: <d6cb8$4b6402e1$524ba3af$12150_at_cache2.tilbu1.nb.home.nl>



Wallyraju wrote:
> Oracle 11g R1
> RHEL (not sure of version)
>
> We are in the process of designing a table(s) in Oracle to store all
> the information pertaining to saving everything related to an email
> being sent out.

Why don't you take a look at the definition of MIME? http://en.wikipedia.org/wiki/MIME looks like a valid starting point. Basically, email is text, so a single CLOB should do it (yes; Clob, not Blob - just take a look at a base64 coded email)

Apart from that - how do you get your mail IN the database? I know about emails: how I can SEND FROM, but I sure would like to RECEIVE INTO the database.

-- 

Regards, Frank van Bortel

Topposting in Usenet groups I regard as offensive - I will not reply
Received on Sat Jan 30 2010 - 03:58:57 CST

Original text of this message