Guidance for Oracle Project

• • Reply

  11 years ago

  by yogendra_maurya

  Yogendra Maurya

  Mumbai, India

  Joined 11 years ago

  Project Details-

  1. A module to monitor a table for insertion (Like Trigger) & on that event it should send a SMS via HTTP Request to our Server. Same module has 2 Update and 1 Insert query for some kind of Data Manipulation. PL/SQL doing same thing takes 9-10 seconds for execution with single HTTP request.

  2. A parallel Module to receive DELIVERY REPORTS as per SMS ID Received while sending.

  3. Volume of insertion in source table can be upto 1000 per Minute (So triggers are not efficient solution)

  4. Main requirement is software as well as database should not get crash in any circumstances.

  Now we are seeking alternative & optimum solution of triggers. Is there any way in Oracle Apps which can be used as a solution? or any other way to do the same thing? Please guide me.

  Report abuse