ICS Datei erstellen und versenden
geschrieben von:
Litetouch (82.113.113.---)
Datum:
Hallo zusammen,
mit folgendem Statement bzw. Prozess erstelle ich mir ICS Dateien:
------------------------------------------------------------------------------
declare
v_titel varchar2(100);
v_begin varchar2(100);
v_end varchar2(100);
v_description varchar2(512);
v_ort varchar2(100);
v_time varchar2(100);
v_bundle varchar2(50);
begin
select xxx, xxx, xxx, xxx, xxx
into v_titel, v_description, v_begin, v_end, v_bundle
from xxx;
v_ort := 'xxx';
v_time := 'xxx';
v_description := replace(v_description,chr(13),'=0D=0A');
v_description := replace(v_description,chr(10));
owa_util.mime_header('application/hbs-vcs', FALSE);
htp.p('Content-Disposition: attachment; filename="'||v_bundle||'_'||v_begin||'_'||v_end||'_download.ics"');
owa_util.http_header_close;
htp.prn('BEGIN:VCALENDAR' || chr(13) || CHR(10));
htp.prn('PRODID;ENCODING=QUOTED-PRINTABLE:Termin' || chr(13) || CHR(10));
htp.prn('VERSION:1.0' || chr(13) || CHR(10));
htp.prn('BEGIN:VEVENT' || chr(13) || CHR(10));
htp.prn('TZ:-1' || chr(13) || CHR(10));
htp.prn('DTSTART:' || v_begin || chr(13) || CHR(10));
htp.prn('DTEND:' || v_end || chr(13) || CHR(10));
htp.prn('TRANSP:TRANSPARENT' || chr(13) || CHR(10));
htp.prn('LOCATION;ENCODING=QUOTED-PRINTABLE:' || v_ort || chr(13) || CHR(10));
htp.prn('DESCRIPTION;ENCODING=QUOTED-PRINTABLE:' || v_description || chr(13) || CHR(10));
htp.prn('SUMMARY:' || v_bundle || ': ' || v_titel || chr(13) || CHR(10));
htp.prn('END:VEVENT' || chr(13) || CHR(10));
htp.prn('END:VCALENDER' || chr(13) || CHR(10));
htmldb_application.g_unrecoverable_error := true;
end;
------------------------------------------------------------------------------
Diese würde ich nun gerne gleichzeitig bei der Erstellung per Email verschicken. Wer weiß hierzu Rat?
Im Voraus Vielen Dank.
Litetouch