Home » Developer & Programmer » Forms » automatically email in oracle not using form
automatically email in oracle not using form [message #293245] Fri, 11 January 2008 06:04 Go to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
AOA

any one help me that how i generate automatically email when

every any one enter record it send mail on my email address.

that a new record has been inserted
Re: automatically email in oracle not using form [message #293246 is a reply to message #293245] Fri, 11 January 2008 06:11 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Try Database trigger after inserting using utl_mail.

>>every any one enter record it send mail on my email address.

I think it's useless. May i know your exact requirement.

Babu
Re: automatically email in oracle not using form [message #293508 is a reply to message #293245] Sun, 13 January 2008 19:12 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Also review and consider 'utl_smtp' and 'utl_tcp'.

David
Re: automatically email in oracle not using form [message #293531 is a reply to message #293245] Sun, 13 January 2008 23:53 Go to previous messageGo to next message
hamidmahmood
Messages: 30
Registered: August 2006
Member
AOA

dear if any one have sample of this plz send me thanks a lot
Re: automatically email in oracle not using form [message #293541 is a reply to message #293531] Mon, 14 January 2008 00:51 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Search!!! Samples exist!!! We do NOT spoon-feed people in this forum.

David
Previous Topic: message must move left continuously like ticker tape on TV screen like oracle
Next Topic: forms on web
Goto Forum:
  


Current Time: Fri Dec 09 22:58:48 CST 2016

Total time taken to generate the page: 0.07987 seconds