Email from Procedure and compare

[dreamerw7]

Hi,

I was wondering if anyone had any ideas as to the easiest way to do the following:

Send an email from Oracle every time a certain table is populated.


Include in the email comparisons of columns if neither is null.

Thanks in advance.

 

[JamesLean]

I have no experience of Oracle but in SQL Server you would probably do this using an insert trigger.

This question would probably be better off in the specific Oracle forum as it has nothing really to do with ANSI SQL.

--James

 

[carp]

I would also use an insert trigger that would call an emailing procedure. If you need such a procedure, check in the Oracle8 FAQ section.

And this thread WOULD be more appropriate in an Oracle forum.