trigger on entry

[Ratzie]

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...

[Steven E. Protter · Accepted solution]

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

[Eric Antunes]

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

[SSCHAER]

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

[Ratzie]

Muchly appreciated, will try