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

MS Sql Server LazyDBA home page