SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL to spool data and send via email

Ryansun-OracleJun 28 2012 — edited Jun 29 2012

Hi,

I have a requirement, to spool, to columns from a table and email the contents everyday maybe scheduling it through a concurrent program. The data will be around 200-400 records, from two columns. Just wanted to check what would be the best approach?

1. Directly spool the data and email the contents using UTL_Mail.
2. Spool the data and then add then send the output as an attachment via email? Not sure how to do this. I mean is the file spooled and we need to pass the location of the attachment?

Or if anyone can advise better or have suggestions

thanks,
Sun

Edited by: ryansun on Jun 28, 2012 8:37 AM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 27 2012

Added on Jun 28 2012

3 comments

950 views