Re: saving emails in an Oracle table
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sat, 30 Jan 2010 16:42:18 +0100
Message-ID: <4b64535a$0$22935$e4fe514c_at_news.xs4all.nl>
Op 30-1-2010 10:58, Frank van Bortel schreef:
> 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.
>
Date: Sat, 30 Jan 2010 16:42:18 +0100
Message-ID: <4b64535a$0$22935$e4fe514c_at_news.xs4all.nl>
Op 30-1-2010 10:58, Frank van Bortel schreef:
> 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.
>
ORACLE_MAIL can run as a mail server. Don't know if it is still there as a stand alone database feature. That's why your client uses Collaboration Suite...
Shakespeare Received on Sat Jan 30 2010 - 09:42:18 CST