Mail Client in Oracle Database

Yes you can receive Mail and send in Oracle Database and store into Database or manipulate email to do some task.
I m always lazy to do some repetative task In my Work i was always ask to do send status of certain task from Database and send to back to them via mail. for a beginning it is fun. but when the request number is increasing it is getting boring and monotonous. so what i did is i installed Mail client in one the schema in my Database which reads emails. then i scheduled the job which reads subject of emails that has keyword [Status] and followed by Report Name. so the scheduler reads and do query and generate report in clob and sends the output to sender Mail.

Leave a Reply

Your email address will not be published. Required fields are marked *