Re: saving emails in an Oracle table

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Sun, 31 Jan 2010 23:24:40 +0100
Message-ID: <4b66032c$0$22933$e4fe514c_at_news.xs4all.nl>

Op 31-1-2010 11:13, Frank van Bortel schreef:

> Shakespeare wrote:
>> Op 30-1-2010 19:10, Frank van Bortel schreef:
>>> Shakespeare wrote:
>>>> 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
>>>
>>> That's why I said "database"... Not some overpriced Oracle (or any)
>>> product. Nowadays the database is used for almost anything, so
>>> why not mail receiver? It's a web browser, an email server, an
>>> application server (HTTP as well as java), an eh... what else?
>>> Oh yeah - right. You might store data, too. In XML format...
>>>
>>
>> IIRC, oracle mail was just a set of database packages....
>>
>> 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 Received on Sun Jan 31 2010 - 16:24:40 CST