This content has been marked as final. Show 8 replies
One way ,you can schedule a job (procedure) in DB which run on desired time that in turn call your C/C++ proc.
Thanks for the reply.
Please consider the scenario.
"Multiple merchants has logged in the portal, and have configured the settlement time of the transactions at a particular time. The settlement time configured by the merchants wiill varry across the merchants, and is not a single fixed time. hence we cannot run the procedure at a particular time. Multiple events or notifications has to be generated at the timming configured by the merchants only"
Hope i am able to explain the problem. Please revert with any suitable solution.
Have a look at Oracle AQ - Advance Queues. Oracle sessions & jobs can enqueue a message. Your C#/C++ code uses PL/SQL to dequeue the message and process it.1 person found this helpful
Alternatively (less robust and scalable), DBMS_PIPE can be used.
Can u please give sample codes for AQ
How to enqueue the messages automatically and i dont want to manage them, it should be time based events which should happen automatically.Please give me a solution for the above problem.
Thanks in advance
I found out the solution