Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: double line spacing in smtp
Thanks, I'll add some more details and hopefully you can help after you
come back from your hols.
On oracle 9.2.0.6 on windows2000 server.
Used demo_mail package from
http://www.oracle.com/technology/sample_code/tech/pl_sql/htdocs/maildemo_sql.txt
DECLARE
conn utl_smtp.connection; req utl_http.req; resp utl_http.resp; data RAW(32767); v_file_handle utl_file.file_type;v_file_name VARCHAR2(60) := 'wor020_665126.lis'; i PLS_INTEGER;
flen NUMBER; bsize NUMBER; ex BOOLEAN;
sender => 'Me <me_at_some-company.com>', recipients => 'Mike <mike_at_home.co.uk>', subject => 'Attachment Test', mime_type => demo_mail.MULTIPART_MIME_TYPE); demo_mail.attach_text( conn => conn, data => '<h1>Hi! This is a test.</h1>',mime_type => 'text/html');
utl_file.fgetattr('ORABIN', v_file_name, ex, flen, bsize); v_file_handle := utl_file.fopen('ORABIN', v_file_name, 'r' ); utl_file.get_raw(v_file_handle, data, flen); utl_file.fclose(v_file_handle);
demo_mail.attach_base64(conn => conn, data => data, mime_type => 'application/octet-stream', inline => TRUE, filename => v_file_name, last => TRUE);
END; Received on Mon Sep 26 2005 - 09:00:02 CDT