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
Accepted Solution
Pegasystems Inc.
IN
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)
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
Virtusa
IN
Thansk for the confirmation :)