how to run an application using oracle -


i have application running on server. every second application checks inserted rows in table. after row inserted application sends necessary info via email. so, connection db (means session) effects system performance. takes lot of memory.

is possible implement in way oracle executes batch file (batch file execute application) after row inserted? if yes, how that?

p.s.: batch file has been prepared , working fine me.

some methods making process sort-of asynchronous are:

  1. triggers - perhaps after statement trigger kicks off job.
  2. dbms_scheduler - create job runs every x minutes , processes rows flag not set. flag should indexed.
  3. continuous query notification‌​ - notify application when relevant row has changed.

Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -