Question
2
Replies
953
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
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