Unable to call Procedures with parameters from GEL

Products

• Clarity PPM On Premise

Issue/Introduction

Processes which call stored procedure fail with error ORA-06576: not a valid function or procedure name

Environment

Release : 16.0.3+

Cause

Broadcom made a decision to change the driver from DataDirect to the Native driver in Clarity 16.0.3, and DataDirect was not mindful of these expectations which native drive does not allow.

Resolution

Clarity will pass the SQL code to the driver to execute at the database 

• Review and run your custom code in database client tools like Oracle SQL Developer/Toad/DBeaver first, and use the working code in your GEL script.
• Use good coding best practices and pass the right datatype.
• Do not use schema aliasing when calling within Clarity.

Additional Information

Jobs that execute a Stored Procedure fail