sending email via pl/ sql using query

<span style='font-size:10.0pt;

font-family:Arial'>List,

<span style='font-size:

10.0pt'> 

<span style='font-size:

10.0pt'>I am trying to send email from Oracle when a table is updated.

<span style='font-size:

10.0pt'>The message must be a dynamic one, so hard coded message will not be allowed.

<span style='font-size:

10.0pt'> 

<span style='font-size:

10.0pt'>I have created a trigger when the table is updated - that works

<span style='font-size:

10.0pt'>I am using UTL_SMTP to send emails. - <span style='mso-spacerun:yes'> that works

<span style='font-size:

10.0pt'>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.

<span style='font-size:

10.0pt'>The query will return more than 1 row.

<span style='font-size:

10.0pt'> 

<span style='font-size:

10.0pt'>- So the trigger executes when a column is updated.

<span style='font-size:

10.0pt'>- A query would be executed giving the required information to be mailed.

<span style='font-size:

10.0pt'>- email program must kick off, emailing the results of the above query.

<span style='font-size:

10.0pt'> 

<span

style='font-size:10.0pt'>Any ideas how to do this.

<span style='font-size:

10.0pt'> 

<span style='font-size:

10.0pt'>Thanks & Regards

<span style='font-size:

10.0pt'>Suhen

<span style='font-size:

10.0pt'> 

<span style='font-size:

10.0pt'>  Received on Thu Jan 31 2002 - 21:31:29 CST