When updating to version 5.4 the procedure fails because of very large query that updates value maps:

[Z3005] query failed: [-1] ORA-00028: your session has been killed [update items set valuemapid=21 where (itemid between 20679 ....

The query in this case contains more than 13k parameters.
Although this query fails from the DB side, still it's probably safer to set some limit to how many parameters should be passed in such queries, as it might fail in many scenarios.