Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

trigger on entry

SOLVED
Go to solution
Ratzie
Super Advisor

trigger on entry

I know I should probably source elsewhere but the help that I receive from this site is the best.
Oracle 10.2.0.2
Is there a way to write a trigger, ( new to this ) that upon entry in the table that if column2 has entry of 5032, send an alert, via email or such, I do not know if this is possible...
4 REPLIES
Steven E. Protter
Exalted Contributor
Solution

Re: trigger on entry

Shalom,

Outside my comfort zone but here is some documentation:

http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_7004.htm

http://www.psoug.org/reference/table_trigger.html

http://www.adp-gmbh.ch/ora/sql/create_trigger.html

http://members.tripod.com/mdameryk/CreateOrclTrgr.htm

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: trigger on entry

Hi,

There is an issue with triggers on the database and third party stuffs: the Oracle database can rollback changes but cannot rollback an e-mail already sent.

Your trigger should be like:

CREATE OR REPLACE TRIGGER .
after insert on .
for each row
DECLARE
...
BEGIN
if :new.column2 = '5032' then
send e-mail (I don't know any package utility to do that...)
end if;
END;


Eric Antunes
Each and every day is a good day to learn.
SSCHAER
Advisor

Re: trigger on entry

inside the trigger simply execute the dbms_mail package and use the send function.
Ratzie
Super Advisor

Re: trigger on entry

Muchly appreciated, will try