GEL Scripts Error ORA-06576 After Upgrading

Products

• Clarity PPM On Premise

Issue/Introduction

After upgrading to 16.1.1, none of the GEL scripts in the processes that calls stored procedures are working.
They all error out with the following:

SQL error: org.apache.commons.jelly.JellyTagException: null:23:17: <sql:update> CALL NIKU.Z_EXAMPLE_SP: ORA-06576: not a valid function or procedure name

Environment

Release : 16.1.1+

Resolution

There was a driver change starting in 16.0.3+ , which causes errors with ambiguous code.

The solution is to make a copy of the script and edit the script to include parenthesis in the reference to call the procedure, e.g.
from
call NIKU.Z_EXAMPLE_SP 
to
call NIKU.Z_EXAMPLE_SP()