SPPR_SYS_RESERVEQUEUEITEM_B stored procedure does not work
PRQueueException occurs after installing HFix-28176 and running the SPPR_SYS_RESERVEQUEUEITEM_B stored procedure.
com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: 1008 SQLState: 72000 Message: ORA-01008: not all variables bound
ORA-06512: at "SCHEMA.SPPR_SYS_RESERVEQUEUEITEM_B", line 114
Steps to Reproduce
- Install the updated SPPR_SYS_RESERVEQUEUEITEM_B supplied with HFix-28176.
- Start the system.
The ORA-06512 was caused due to a coding error in the body of the stored procedure.