Community discussion forum

Guidance for Oracle Project

• • Reply

  5 months ago

  by yogendra_maurya

  Yogendra Maurya

  Mumbai, India

  Joined 5 months 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.

  Post was edited on 01/06/2009 05:45:40 Report abuse