OraFAQ Forum: SQL & PL/SQL » how to send email when the status of the object gets invalid?

Home » SQL & PL/SQL » SQL & PL/SQL » how to send email when the status of the object gets invalid? (11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to send email when the status of the object gets invalid? [message #614741]

Mon, 26 May 2014 13:10

kiranrathodkr916
Messages: 36
Registered: March 2014
Location: India

Member

I have couple of stored procedures and a package whenever this stored procedure and package goes invalid , i need to send an email.how can i achieve this.can u pls give me an idea how this can be done

Report message to a moderator

Re: how to send email when the status of the object gets invalid? [message #614743 is a reply to message #614741]

Mon, 26 May 2014 13:12

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Simply log it and use the error log details to send an email.

Report message to a moderator

Re: how to send email when the status of the object gets invalid? [message #614744 is a reply to message #614743]

Mon, 26 May 2014 13:15

kiranrathodkr916
Messages: 36
Registered: March 2014
Location: India

Member

can u explain in detail

Report message to a moderator

Re: how to send email when the status of the object gets invalid? [message #614749 is a reply to message #614744]

Mon, 26 May 2014 13:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

you can send email message using UTL_MAIL
http://docs.oracle.com/cd/E16655_01/appdev.121/e17602/u_mail.htm#ARPLS384
There is no (good) reason to send email when package goes INVALID.
any invalid package will automatically be compiled then next time it is executed.

Report message to a moderator

Previous Topic:	Delimited by '\' in oracle external table
Next Topic:	SQL or PL/SQL query to sum and avg time stamps

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 00:41:52 CDT 2024