Home » SQL & PL/SQL » SQL & PL/SQL » email notification using oracle advance queue (oracle advance queue)
email notification using oracle advance queue [message #571616] Wed, 28 November 2012 03:11 Go to next message
chakri7276
Messages: 2
Registered: November 2012
Location: India
Junior Member
Hi,
I want to send an email notification using oracle aq for events like when a message goes to error queue.
Similarly,Can I send an email notification when I create a queue or drop a queue?
How can I do this?
If anybody can share an example or any code snippet it would be very useful.

[Updated on: Wed, 28 November 2012 03:19]

Report message to a moderator

Re: email notification using oracle advance queue [message #571618 is a reply to message #571616] Wed, 28 November 2012 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Can I send an email notification when I create a queue or drop a quru.
How can I do this?


Create a DDL trigger.

Regards
Michel
Re: email notification using oracle advance queue [message #571619 is a reply to message #571618] Wed, 28 November 2012 03:22 Go to previous messageGo to next message
chakri7276
Messages: 2
Registered: November 2012
Location: India
Junior Member
How can i send an email notification in the DDL trigger?
Is there any standard API for doing this?
Re: email notification using oracle advance queue [message #571621 is a reply to message #571619] Wed, 28 November 2012 03:49 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.
UTL_MAIL.

Regards
Michel
Previous Topic: performance tuning of the query
Next Topic: how to gip zip using pl/sql
Goto Forum:
  


Current Time: Sun Dec 21 19:40:50 CST 2014

Total time taken to generate the page: 0.07881 seconds