Home » RDBMS Server » Server Administration » sending a file as an email attachment using utl_smtp (Oracle 9.0.2.0.6 Windows Server 2003)
sending a file as an email attachment using utl_smtp [message #305219] Mon, 10 March 2008 03:20 Go to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Dear All,

i have a .csv file and i want to send this file as an attachment using utl_smtp

e.g i had a file abc.csv located at d:\omails and when i call the procedure ,it pick the file d:\omails\abc.csv and send this file as an attachment to specific recipients

Please suggest!

Re: sending a file as an email attachment using utl_smtp [message #305223 is a reply to message #305219] Mon, 10 March 2008 03:25 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Asktom Attachment with the e-mail using utl_smtp

Remember PL/SQL only knows LOCAL (that is instance server) files not client one.

Regards
Michel
Re: sending a file as an email attachment using utl_smtp [message #305267 is a reply to message #305223] Mon, 10 March 2008 05:07 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Also see Send mail from PL/SQL.
Previous Topic: can't determine ORACLE_HOME FOR sid ebs
Next Topic: Raw disk / partition from Filer (FAS-940)
Goto Forum:
  


Current Time: Sun Dec 04 16:53:12 CST 2016

Total time taken to generate the page: 0.10028 seconds