• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 424
  • Last Modified:

Concurrent requests dependency?

Hi,

I have a scenario where concurrent request A is submitted and a while later B. Now the catch is that B should run only once A is complete. Is there any means by which this can be achieved?
At present, what happens is that B gets done before A and hence A ends up retrieving incorrect data from the database.

Thanks.
0
Bharath_Raj
Asked:
Bharath_Raj
4 Solutions
 
Geert GruwezOracle dbaCommented:
this is something which is in the design of the application
so you need to specify how the application does the processing
or post the code of handling the requests
0
 
sdstuberCommented:
you can wrap A and B in a single process C where C calls A then B.

If that isn't possible, you can use alerts, where A raises an alert  and B runs but waits for the alert.
or use dbms_pipes to communicate between them
or have A submit a dbms_job that invokes B , and then B will be queued but won't start until A commits
or use sockets to communicate
or use a dbms_job that polls the status of A by some means and when it detects A is done it starts B
0
 
Franck PachotCommented:
Hi,
You can also use enqueues: A and B both lock the same resource.
That can be a row if it has a meaning , or you can use dbms_lock package.
Regards,
Franck.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Mark GeerlingsDatabase AdministratorCommented:
Is this a generic Oracle question involving a custom application, or is this an Oracle Applications (or EBS) issue involving Concurrent Manager programs?  In EBS, you should be able to define the two jobs so only one cof the two can be running at a time.
0
 
sdstuberCommented:
Please accept one or  more of the answers above that best helped you.
0
 
sdstuberCommented:
If no indication from author then I recommend split

http:#26071186
http:#26071222
http:#26072686
http:#26080862

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now