RE: Emailing Attachment via PL/SQL Procedure?

RE: Emailing Attachment via PL/SQL Procedure?

 

  

I am sending files as attachments through unix shell scripts not quiet
sure how to do it with PL/SQL?

-----Original Message-----
From: Nowitz Marcelle
[mailto:oracledba-ezmlmshield-x3219265.[Email address protected]
Sent: Wednesday, May 28, 2008 1:04 PM
To: LazyDBA Discussion
Subject: Emailing Attachment via PL/SQL Procedure?

Using Oracle 9i, I need to send a fairly large amount of data via email
(around 3k records) and wondered if anyone knew of a way to email it in
a text file as an attachment rather than as the body of the email. I
have been using utl_smtp (calling another procedure), but there appears
to be some limitations to size as well as some strange formatting
issues. Any suggestions on accomplishing this task?



Regards,

Marcelle





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page