Home » RDBMS Server » Server Administration » Object creation should pop up a mail  () 1 Vote
Object creation should pop up a mail [message #330955] Tue, 01 July 2008 23:08 Go to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
Guys,


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

Arvind
Re: Object creation should pop up a mail [message #330956 is a reply to message #330955] Tue, 01 July 2008 23:09 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
Please read & follow Posting Guidelines below
http://www.orafaq.com/forum/t/88153/0/
Re: Object creation should pop up a mail [message #330958 is a reply to message #330955] Tue, 01 July 2008 23:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
trigger + utl_mail

Regards
Michel
Re: Object creation should pop up a mail [message #330962 is a reply to message #330955] Tue, 01 July 2008 23:20 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
thx Micheal. Can you please provide me the sample script for the same?

Arvind
Re: Object creation should pop up a mail [message #330964 is a reply to message #330962] Tue, 01 July 2008 23:23 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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?
Re: Object creation should pop up a mail [message #330965 is a reply to message #330955] Tue, 01 July 2008 23:25 Go to previous messageGo to next message
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
Re: Object creation should pop up a mail [message #330967 is a reply to message #330965] Tue, 01 July 2008 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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 Go to previous messageGo to next message
ArvindBhope
Messages: 55
Registered: June 2008
Member
we are getting dicerted here.
Re: Object creation should pop up a mail [message #330972 is a reply to message #330955] Tue, 01 July 2008 23:49 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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?
Re: Object creation should pop up a mail [message #330976 is a reply to message #330962] Tue, 01 July 2008 23:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Object creation should pop up a mail [message #331101 is a reply to message #330955] Wed, 02 July 2008 05:40 Go to previous messageGo to next message
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 ?
Re: Object creation should pop up a mail [message #331112 is a reply to message #331101] Wed, 02 July 2008 05:50 Go to previous messageGo to next message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Whenever we create the table in the dtabase where does it get updated in the dictionary table ?

In many tables.

Quote:
what is its name ?

The one you gave

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

No, you can't put a trigger on SYS tables.

Regards
Michel
Re: Object creation should pop up a mail [message #331132 is a reply to message #331112] Wed, 02 July 2008 06:01 Go to previous messageGo to next message
VenkatMethuku
Messages: 8
Registered: June 2008
Junior Member
i meant the base table?

thanks,
Venkat.
Re: Object creation should pop up a mail [message #331140 is a reply to message #331132] Wed, 02 July 2008 06:14 Go to previous message
Michel Cadot
Messages: 64126
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is "base table"?

Regards
Michel
Previous Topic: install oracle 7.3.4.5.0
Next Topic: SQl net tracing
Goto Forum:
  


Current Time: Wed Dec 07 06:44:01 CST 2016

Total time taken to generate the page: 0.05666 seconds