ional
-Original Message-From: Suhen Pather
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 31,
2002 10:25 PMTo: Multiple recipients of list
ORACLE-LSubject: sending email via pl/ sql using
query
List,
I am trying to send email from Oracle when a table is
updated.
The me
bruary 01, 2002 5:25 AM
> To: Multiple recipients of list ORACLE-L
> Subject: sending email via pl/ sql using query
>
> 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
>
Suhen,
You should be able to pass in the values returned from your query as a
'variable' to the utl_smtp.write_data command. I've used an example from the
asktom.oracle.com website (
http://asktom.oracle.com/pls/ask/f?p=4950:8:457115::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:2118740358226,%7But
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 proced