Question
2
Replies
976
Views
Posted: April 5, 2018
Last activity: April 12, 2018
Closed
Solved
SPPR_SYS_RESERVEQUEUEITEM_B | 7.3.1 | Update
Hi All,
Could someone update in the below Post.
https://pdn.pega.com/support-articles/spprsysreservequeueitemb-stored-proc-leave-cursors-open
Its not clear in the post what should be the exact SQL after the changes. The block WHEN NO_DATA_FOUND THEN is in multiple places.
It will be better if the exact SQL for the procudure is been shared / updated in the post.
Thanks
Moderation Team has archived post,
Close popover
This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Hi,
Not sure exactly what's the confusion here.
But if you open this SP sppr_sys_reservequeueitem_b in 7.3.1 you will find the updated script around line 130
Here a better screenshot
The text in red highlights are the modifications
Whereas if you look the older SP in older version its as shown below (took from 6.3)
So I think this is already updated in latest version so you would not have to make any changes
Let me know if I got something wrong here
Thank You