topic Re: trigger on entry in Operating System - HP-UX

trigger on entry

Ratzie — Wed, 25 Mar 2009 15:29:23 GMT

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

Re: trigger on entry

Steven E. Protter — Wed, 25 Mar 2009 16:18:32 GMT

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

Re: trigger on entry

Eric Antunes — Thu, 26 Mar 2009 16:03:42 GMT

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

Re: trigger on entry

SSCHAER — Fri, 27 Mar 2009 08:12:12 GMT

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

Re: trigger on entry

Ratzie — Thu, 05 Nov 2009 16:18:58 GMT

Muchly appreciated, will try