Home » SQL & PL/SQL » SQL & PL/SQL » Sending emails,sms.......
Sending emails,sms....... [message #39723] Mon, 05 August 2002 03:25 Go to next message
Vinayak Awasthi
Messages: 19
Registered: October 2001
Junior Member
hi all,
i have a table updated_records in the database(it contains customer id field along with others).I want to develop an application in which whenever a new record is added in this table, an email or sms should be sent to the particulaur customer.This should happen from backend.

Any suggestions

Vinayak

Report message to a moderator

Re: Sending emails,sms....... [message #39743 is a reply to message #39723] Tue, 06 August 2002 21:30 Go to previous message
jose prakash
Messages: 2
Registered: April 2002
Junior Member
HI Vinayak

You can send E mail through database by utl_smtp .
write an after insert trigger for the table and
you can then make use of UTL_SMTP
all the best
-jose prakash

Report message to a moderator

Previous Topic: Re: DECODE explanation
Next Topic: I need INITCAP to ignore apostrophes.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 09:20:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.