email notification

[èDó]

Good day everyone.

Can i send an email in a pl/sql block?
I need to inform users about things regarding the data stored in the database. When the data meets the condition in the where clause, i need to notify the users through email. Is that possible? Can i use jobs for this?

Tnx a lot..

èDó

[clio_usa]

Sure you can.

Oracle made is easy with UTL_SMTP package.

For more info and examples visit the latest Oracle DBA forums at: http://www.dbaclick.com/cgi-bin/ib3/...=ST;f=15;t=287

Hope that helps,

--clio_usa
Senior Oracle DBA

[TimHall]

Try this:

http://www.oracle-base.com/Articles/...romPLSQL9i.asp

It works for 8i and 9i.

Cheers