Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Multiple session in procedure

Sohail AnwarFeb 1 2018 — edited Feb 2 2018

Dear All,

I have a custom table in which there are more than 200,000+ records. I have to update 3 fields. I want to know is there any possibility to run multiple sessions inside a procedure so that it could process multiple sets of rows in a single run. For example first session will update rows between line_number 1 and 25000. Second session will process lines between line_number 25001 and 50000 and so on. I will run procedure from EBS 12.1.3 as a concurrent request.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2018
Added on Feb 1 2018
21 comments
1,674 views