OraFAQ Forum: Server Administration » Object creation should pop up a mail

Home » RDBMS Server » Server Administration » Object creation should pop up a mail (

) 1 Vote

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

Object creation should pop up a mail [message #330955]

Tue, 01 July 2008 23:08

ArvindBhope
Messages: 55
Registered: June 2008

Member

Guys,

Object creation should pop up a mail. Any guess how could this be achieved ?

Arvind

Report message to a moderator

Re: Object creation should pop up a mail [message #330956 is a reply to message #330955]

Tue, 01 July 2008 23:09

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Object creation should pop up a mail [message #330958 is a reply to message #330955]

Tue, 01 July 2008 23:13

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

trigger + utl_mail

Regards
Michel

Report message to a moderator

Re: Object creation should pop up a mail [message #330962 is a reply to message #330955]

Tue, 01 July 2008 23:20

ArvindBhope
Messages: 55
Registered: June 2008

Member

thx Micheal. Can you please provide me the sample script for the same?

Arvind

Report message to a moderator

Re: Object creation should pop up a mail [message #330964 is a reply to message #330962]

Tue, 01 July 2008 23:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ArvindBhope wrote on Tue, 01 July 2008 21:20

Can you please provide me the sample script for the same?

Arvind

Isn't that YOUR job?

Report message to a moderator

Re: Object creation should pop up a mail [message #330965 is a reply to message #330955]

Tue, 01 July 2008 23:25

ArvindBhope
Messages: 55
Registered: June 2008

Member

I was expecting a sample script on this hence the query!! FYI: a trigger creation is new to me.

thanks

Report message to a moderator

Re: Object creation should pop up a mail [message #330967 is a reply to message #330965]

Tue, 01 July 2008 23:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

ArvindBhope wrote on Tue, 01 July 2008 21:25

I was expecting a sample script on this hence the query!! FYI: a trigger creation is new to me.

thanks

Why are you expecting other to do your job for you?
Are you saying that you have never written a PL/SQL procedure?

[Updated on: Tue, 01 July 2008 23:34] by Moderator

Report message to a moderator

Re: Object creation should pop up a mail [message #330970 is a reply to message #330955]

Tue, 01 July 2008 23:44

ArvindBhope
Messages: 55
Registered: June 2008

Member

we are getting dicerted here.

Report message to a moderator

Re: Object creation should pop up a mail [message #330972 is a reply to message #330955]

Tue, 01 July 2008 23:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>we are getting dicerted here.
WE? I don't think that include most folks here; whatever "dicerted" may mean.

Why are you expecting other to do your job for you?
Are you saying that you have never written a PL/SQL procedure?

Report message to a moderator

Re: Object creation should pop up a mail [message #330976 is a reply to message #330962]

Tue, 01 July 2008 23:59

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SQL Reference
CREATE TRIGGER

Database Application Developer's Guide - Fundamentals
Chapter 9 Coding Triggers

There are many examples on mail usage here or on AskTom.

Regards
Michel

Report message to a moderator

Re: Object creation should pop up a mail [message #331101 is a reply to message #330955]

Wed, 02 July 2008 05:40

VenkatMethuku
Messages: 8
Registered: June 2008

Junior Member

Whenever we create the table in the dtabase where does it get updated in the dictionary table ?what is its name ?

can we use that in a trigger creation as base object ....like when insert happens ?

Report message to a moderator