- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
Hi,
I have found that table NmsBroadLogRcp is updated in batches
For ex. like
UPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000
I'm looking for solution how to manage batch size to avoid too many loops.
Those value is any defined parameter ?
Thanks in advance
Solved! Go to Solution.
Views
Replies
0 Likes
Total Likes