Thanks for the reply, have already looked there, but was hoping to stay away
from Java! and use straight PL/SQL and db packages. May result using a
script on the OS box with just "mail <address here> < /tmp/report.csv".

-----Original Message-----
From: Regis Biassala [mailto:Regis.[Email Address Removed] 10 September 2003 09:35
To: LazyDBA.com Discussion
Subject: RE: Email & Attachments from db?


Yes,
go to asktom.oracle.com, he has an example on how to send mail and
attachments from Oracle8i.
I think for the attachement you'll use java stored procedure(jsp)...Just
search there.

All the best,
Regis


-----Original Message-----
From: Darren S. Eyers [mailto:[Email Address Removed] Wednesday, September 10, 2003 9:20 AM
To: LazyDBA.com Discussion
Subject: Email & Attachments from db?


Hi All,
I can use utl_smtp to send emails though the database (Oracle 8172). I
would like to get some results from a table and attach the results as a file
attachment.

Any ideas how this can be done? I think I will have to use utl_file
unfortunately as would of been nice not to use it. As we do not have any
web application server I can not use UTL_HTTP. Also due to security will
not be able to add bespoke scripts to the box.

Any ideas?

Regards
Darren


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page