Hello all

I have read every bit of information I can find about the UTL_SMTP package but I can't find a solution to my situation. I was hoping someone could help me out

I want send an e-mail with data gathered from a stored proc in the body of the meesage.

I.E. execute a stored procedure that will gather hockey pool stats for each user and send a e-mail to that user with their stats in the body of the message.

All the expamles I have seen so far are using static bodies for the e-mails. Has anyone out there used this package to create dynamic e-mail messages