sending email via pl/ sql using query

[Suhen Pather]

List,   I am trying to send email from Oracle when a table is updated. The message must be a dynamic one, so hard coded message will not be allowed.   I have created a trigger when the table is updated - that works I am using UTL_SMTP to send emails. - �that works However this procedure (send_mail) only has hard-coded messages. - I need it to be a dynamic message, from a query which I already have. The query will return more than 1 row.   - So the trigger executes when a column is updated. - A query would be executed giving the required information to be mailed. - email program must kick off, emailing the results of the above query.   Any ideas how to do this.   Thanks & Regards Suhen   �