Project Details-
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.
A parallel Module to receive DELIVERY REPORTS as per SMS ID Received while sending.
Volume of insertion in source table can be upto 1000 per Minute (So triggers are not efficient solution)
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.
!--removed tag-->
No one has replied yet! Why not be the first?
Sign in or Join us (it's free).