Re: utl_smtp -> meeting request

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 29 Mar 2007 22:51:12 -0700
Message-ID: <1175233872.020035.325950@r56g2000hsd.googlegroups.com>

On Mar 29, 8:20 am, "GK" <a..._at_c.d> wrote:
> Hello,
>
> Is there a way to send out E-mail meeing requests (Outlook) using utl_smtp ?
> If yes, how ?
> Oracle version: 9i
>
> thanks,
> GK

Yes, it's possible if you know the format of meeting requests sent by Outlook. Outlook meeting request is actually just a plain text message of MIME type "text/calendar", XML-like in that it's hierarchical, but not XML as it uses different tagging scheme: BEGIN: name ... END: name on separate lines. Surely there should be no problems emailing plain text messages using documented UTL_SMTP API.

Now if the question actually is "what is the format of MS Outlook calendar events?" then I have no ready answer but "browse MSDN Library at http://msdn.microsoft.com/library, it may well be documented there." Otherwise you can send yourself a few different requests, check their raw content and figure out the format.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Fri Mar 30 2007 - 00:51:12 CDT