Triggers anyone?
Originally Posted by
pszleter
Is there any way to determine if a DML event such as select or insert was finished?
I need to fire one process and it has to be done right after updating one of the tables. I am wondering if there is something like timestamp for DML event (equivalent of LAST_DDLTIME for DDL invents)?
Your requirement is a bit confusing, first you refer to single statements (select or insert) and then you refer to "after updating one table".
Follow my previous post to schedule a processing sequence for the jobs related to "after updating one table".
Otherwise if you need to execute something right after/durinig each statement executing (other than "SELECT"), then the route to go is: Triggers.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote