1 person found this helpful
Please se update your forum profile with a real handle instead of "user12045295".
I have an application with table ISSUES. This table has a column ASSIGNEE_ID, which holds the ID of the user that has been assigned an issue.
Requirement: we want to send a mail to the assignee when an issue has been created or when the assignee_id has been updated. So the process SEND_MAIL is conditional.
What is the syntax for checking that the condition that page item ASSIGNEE_ID has been updated?
There is no basic built-in syntax in APEX or Oracle for this. Create another page item to hold the original ASSIGNEE_ID value (set it's condition to Never so it is not rendered in the page), store the original value using a page show computation/process, and make the SEND_MAIL process conditional on the original and submitted ASSIGNEE_ID being different.
you employ the service or trigger like this
create or replace trigger UPDATE_MAIL before update on ISSUES for each row begin if inserting then SEND_MAIL(p_assignee_id => :new.assignee_id ... ); elsif updating then SEND_MAIL(p_assignee_id => :old.assignee_id ... ); end if; end;
Hope this helps
I Would NOT suggest using an e-mail in a trigger.. Please note the issue posted in a previous thread.. What happens when you rollback a transaction? Base the e-mail being sent via a page process instead....