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!

Report message to a moderator

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: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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: 4581
Registered: April 1998
Senior Member
Also see Send mail from PL/SQL.

Report message to a moderator

Previous Topic: can't determine ORACLE_HOME FOR sid ebs
Next Topic: Raw disk / partition from Filer (FAS-940)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 03:23:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.